Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Generating Excel or PDF without going back to database

edited July 2005 in Server
Hello

I have a report which obtains its data from a database and is displayed in a
web page through a web tier. When the user clicks on the PDF button is
there any way that I can just export the data that is already in the report
straight to a PDF file rather than having to go back through the database?

Cheers

Paul

PS - This is border line between server and devices so have placed in both

Comments

  • edited August 2005
    Please do not crosspost. Just pick a newsgroup that you think is best and
    post once there.

    Report pages (TppPage objects) are generated incrementally upon demand. For
    example, if you preview page 1, then only page 1 is generated. Press the
    next button, then page 2 is generated.

    When you export to a file (PDF or XLS, etc), then all pages are generated.
    If you set Report.CachePages to true, then each page will only be generated
    a single time. In the case of RB Server Edition, both the report server and
    webtier cache page objects (regardless of the Report.CachePages setting).

    Each device receives Page objects and translates them to specific format
    (PDF, XLS, etc).

    In terms of database access, the data is opened at the beginning of the
    report. When page request are made by the devices, the report engine
    traverses data required to generate requested pages.

    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited August 2005
    Sorry Nard

    Thanks for this advice

    Cheers

    Paul

This discussion has been closed.