Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Propagate to individual subreports? (CR 8.5 VCL)

Status
Not open for further replies.

nileshcssi

Programmer
Apr 22, 2003
6
MX
I am using the Crystal Report 8.5 VCL component using Delphi 5. I am trying to propagate the database connection to individual subreports selectively (rather than all of them). According to the documentation it is possible to do this:

property Propagate: boolean;

Designed to take the Connect information from the main Report and use it for the Subreports as well. If Propagate is set to True for the main Report, the Connect information from the main Report will be used for all the Subreports. But if Propagate is set to True while the Crystal VCL is pointing to a Subreport (TCrpe.Subreports[n>0]), then only that Subreport will use the Connect parameters set in the main Report.


I try to use code such as this:
Code:
Crpe1.Subreports[5];
Crpe1.Connect.Propagate := true;
However, this propagates to all subreports and not the individual one. I have also tried this with the same effect:

Code:
Crpe1.Subreports[5].Connect.Propagate := true;

The reason I want to do this is because I have a report that has many subreports. Only a few of these subreports are used and the rest are supressed. Propagating to every subreport means every subreport gets loaded. This is causing a performance problem especially when using the report off of a network drive. Without propagating, the report loads very quickly (only the subreports that are needed are loaded), but unfortunately we need to propagate the connection because the database connection (Oracle) is not static.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top