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

Printing miltiple reports to same Excel File

edited April 2004 in Devices
I want to be able to print a bunch of reports to thesame file. For instance
I want to be able to prints 5 or more reports to one excel spread sheet.
When I try doing this, all the previous excell workbooks get deleted and
only the last printed reported is saved.

Thanks.

Comments

  • edited April 2004
    If using TExtraDevices, you need to run the reports as subreports in order to
    combine them.

    James Waler
    Waler Ltd
    http://www.waler.com
  • edited April 2004
    Using eDocEngine and if you want to do this programmatically, you can do it
    in the following way, without any change to your reports:

    gtRBExportInterface.DoBeginDoc := False;
    gtRBExportInterface.DoEndDoc := False;

    IgtDocumentEngine(gtRBExportInterface.Engine).BeginDoc;

    gtRBExportInterface.RenderDocument(ppReport1); // First report
    IgtDocumentEngine(gtRBExportInterface.Engine).NewPage;
    gtRBExportInterface.RenderDocument(ppReport2); // Second report
    IgtDocumentEngine(gtRBExportInterface.Engine).NewPage;
    gtRBExportInterface.RenderDocument(ppReport3); // Third report
    ...
    IgtDocumentEngine(gtRBExportInterface.Engine).EndDoc;

    The eDocEngine help file has more details on this.
    http://www.gnostice.com/edoc_engine.asp

    --
    Girish Patil
    Gnostice Information Technologies www.gnostice.com
    ---------------------------------------------------------------------
    Gnostice eDocEngine (http://www.gnostice.com/edoc_engine.asp) -
    Electronic document creation, PDF eForms and report export components

    Gnostice PDFtoolkit (http://www.gnostice.com/pdftoolkit.asp) -
    PDF document management and PDF eForms processing components
    ---------------------------------------------------------------------

This discussion has been closed.