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

Multiple Reports in single PDF file

edited October 2007 in General
Hello

I have a report which produced on a location by location basis. We now have
a requirement where our application can go through reports in a batch, ie
Location 1, Location 2, etc

Each location has a LocationID which is provided to the server to generate
the report

I do not want to have to rewrite the report to work for multiple location
ids

Is there a way where I could generate the reports one by one then combine
them together into a single pdf file?

Can I do it with archive files?

I am using Report Builder 10.07

Cheers

Paul

Comments

  • edited October 2007
    Here is an example of generating multiple reports to a single PDF

    www.digital-metaphors.com/tips/MultipleReportsAsOnePDF.zip


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited October 2007
    How would I implement this for reports that are served by a report server?

    The example here does not use a report server, just simple reports

  • edited October 2007
    I am getting there with this but the problem now is that if I run 2 reports
    instead of the output being displayed at the end in a pdf file as it is in
    your example, the reports are still displayed in my client application

    How do I make my report call PrintToDevices? I have a feeling it is
    calling Print?

    I am wondering if I should generate the reports in an ArchiveVolume then
    somehow go through all the reports in the archive volume creating one single
    pdf file?

    Cheers

    Paul
  • edited October 2007

    I recommend posting questions about RB Server applications to the Server
    newsgroup :)


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited October 2007
    ok fair enough but that still does not answer my question!

  • edited November 2007
    Hi

    This solves my problem partially. I do not need the PDF and want to use the
    standard preview window. What changes are needed to realize this ?

    Ad Franse


  • edited November 2007
    Hi Ad,

    The example below is intended to be used with file devices only. If you
    need to merge multiple reports into a single report for previewing or
    printing, the easiest way is to use Section Style subreports in the detail
    band of an empty main report and load each separate report into each
    subreport.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.