Refresh data on second pass

rbuser

Hi !

I've been trying to create a table of contents for a report with groups by
using a Field "pageno" in my dataset, which I update during first pass in
the AfterGroupBreak-Event with the AbsolutePageNo-Property.

Works great, the field is updated in the table, but the report is still
getting the old (=empty) values in the second pass, seems the query is
executed only once when printing starts (I'm using DADE).

How can I force RB to close and reopen the query at the second pass ?

TIA,

Heiko Kn?ttel

nardmoseley

Here is an example of creating a table of contents...

http://www.digital-metaphors.com/tips/TableOfContents.zip


You could perhaps try calling DataPipeline.Close and then DataPipeline.Open.
However, you may encounter some errors. ReportBuilder was not designed to
enable the datasets to be changed while the report is generating. All of the
data is traversed and pagination is calculated during the first pass.




--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com