Master-Detail-Detail

rbuser

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.

nardmoseley

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.