Sub report problems

rbuser

I have created a report with a sub report underneath. On the main report
I have put the titles in the detail band so they appear above the data. This
works most of the time but sometimes the titles appear on the bottom of a
page and the data appears on the next page. How can I keep them together?
The report also takes along time to run as I have got a query for the
sub report that runs for every instance of the main report, is there a
better way of doing this?

Thanks,
John
Liddell

nicocizik

Hi John,

Try placing the labels and subreport into a TppRegion with the KeepTogether
property set to True. This will attempt to keep everything inside the
region together across pages. The subreport by definition will traverse the
data it is connected to as it is generated. If you are loading the same
data over and over again, you might try initially saving that data in some
sort of in-memory object (TStrings) or dataset (kbmMemTable) then using a
JITPipeline to connect the data to the report. This would definitely be the
fastest option for getting data of any kind to a report. See the
ReportBuilder Demo application under the "No Database Reports" for more
information on using JITPipelines in the \RBuilder\Demos\1. Reports\...
directory.

--

rbuser

Nico

Cheers for the help. Putting them in a TppRegion worked great.

John