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

Master-Detail-Detail

edited December 2005 in Subreports
Hi !

I'm working with TStoredProc, TDataSource and TBDEPipeline (Delphi 7) and
Report Builder enterprise version 9.03.
I have made a report for Customer's Invoice in which I have the Master for
the Document header, and Detail for the document line and another detail,
which refers to the document line, for the delivery dates.
I allways open Stored Porcedure for the document header and the document
line, but for the delivery date, I have a subreport in the subreport of
document line which is automatically open at the beginning of the generation
of the report. In the event OnTraversal of the BDEpipeline for document
line, I close the StoredProcedure of delivery dates.
If I create a group, in the subReport document line, on the document line
ID, with KeepTogether = True, the stored Procedure for delivery dates is
open for each document line.
If I create a group with KeepTogether = False I obtain this message "Cannot
perform this operation on a closed DataSet" because the Stored Procedure is
not re-open.
How can I make to automatically open the Stored Procedure for the delivery
dates without create a group with KeepTogether = True ?

Thank's

Valerie.

Comments

  • edited December 2005

    Rather than OnTraversal, try using OnRecordPositionChange.

    To help performance I would also set Report.CachePages to true so that each
    page is only generated once.




    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.