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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub Report

Status
Not open for further replies.

jbaldO

Programmer
Mar 27, 2006
11
AU
Hi All,

Crystal 9.0
Windows XP
Progress Database Version 91d

Is there a way to control the sub-report i.e. process it depending on a parameter?

The reason is that if the user finds it slow to add the sub-report then he can set the parameter to 'dont include/process sub-report'.

Thanks.

Joseph
 
Sure, place the subreport in a seperate section, right click the section and select format section->x2 next to suppress and place the criteria there, as in:

{?MyParmaeter} = "Suppress"

Or you can suppress the subreport itself by right clicking it and selecting format subreport and using a suppression formula for it.

Depends on where the subreport is in the report...

-k
 
Hi,
Thanks for the reply.
Yes, i am already suppressing the sub-report but what i want to achieve is how will i tell the sub-report not to process the records.
This will let the report run faster if the user doesn't want the sub-report to be shown in the main report.
By the way, the report has 4 sub-reports in the details section which the user can suppress individually via parameter.

Thanks.


 
If the section is suppressed, the subreport will not run. So SV's conditional suppression solution should work fine.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry
 
Hi, I am not sure if you have resolved this, but if not it sounds like you could do a : ON-Demand subreport.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top