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

Linking / Merging Multiple Reports Together

edited May 2010 in General
Hi,

I have an application where I have different individual reports on
different forms.

My client has requested an option where they can select which reports
they want to print - and they want to be able to view these selected
reports as one report in a preview window before printing.

I was wondering if this is possible - to merge multiple independant
reports together into one final report for print previewing?

Thanks & Regards

Adam

Comments

  • edited May 2010
    Hi Adam,

    Below are a few options on merging multiple reports into one.

    1. Create a empty main report with only a detail band and place (or create)
    a separate Section subreport for each report you would like to merge. Then
    you can load each report into each section subreport and view the report as
    one.

    2. Use the Archive merge utility (kuRAFMerge) available from our website to
    merge multiple archive files into a single archive then use the
    ArchiveReader to view the merged report.
    http://www.digital-metaphors.com/download/report_component_library.html

    3. Merge each report to a single PDF file using the following technique.
    http://www.digital-metaphors.com/rbWiki/Output/PDF/How_To...Merge_Multiple_Reports_into_one_PDF

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2010
    Hi Niko,

    Thank you for your reply.

    I went with the option of using the kuRAFMerge module as the first
    option requires the other reports to still be active and linked to their
    datasources to work.

    I was wanting to keep everything designed from within the application
    (and tPPReport) so didn't want to go externally with PDF Files.

    I have used the following code to test this, and it appears successful:

    ppreport2.AllowPrintToArchive := true;
    ppreport2.DeviceType := 'ArchiveFile';
    ppreport2.ArchiveFileName := 'c:\temp\~report2.tmp';
    ppReport2.ShowPrintDialog := False;
    ppreport2.print;

    ppreport3.AllowPrintToArchive := true;
    ppreport3.DeviceType := 'ArchiveFile';
    ppreport3.ArchiveFileName := 'c:\temp\~report3.tmp';
    ppReport3.ShowPrintDialog := False;
    ppreport3.print;

    kuRafMerge1.SourceFiles.Clear;
    kuRafMerge1.SourceFiles.add('c:\temp\~report2.tmp');
    kuRafMerge1.SourceFiles.add('c:\temp\~report3.tmp');
    kuRafMerge1.DestinationFile := 'c:\temp\~reportmerged';
    kuRAFMerge1.Execute;

    ppArchiveReader1.ArchiveFileName := 'c:\temp\~reportmerged';
    ppArchiveReader1.DeviceType := 'Screen';
    ppArchiveReader1.Print;


    Thanks again for your help!

    Best Regards

    Adam.
  • edited May 2010

    ReportBuilder has the capability to generate multiple reports reports to
    single file. The file can be of any format: PDF, Archive, TextFile, and now
    with RB 12, RTF, XLS, DOC, etc.

    The technique is the same as shown in this PDF example. (To change the
    example to generate to Archive, you would create an ArchiveDevice.)

    http://www.digital-metaphors.com/rbWiki/Output/PDF/How_To...Merge_Multiple_Reports_into_one_PDF




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



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited May 2010
    Hi Nard,

    Thanks for your reply. I'll give this a shot too and see which one I prefer.

    Have a great weekend!

    Adam.
This discussion has been closed.