Enable/disable sub reports

[vbredpgr]

I have a report which has a subreport in the detail section. I have a parameter for the user to select whether they want a summary or a detailed version of the report. When they select detailed it runs and shows the subreport. When they select summary, it hides the details including the subreport, however, it still runs the stored proc upon which the subreport is based.

I want to keep it from running this stored proc when they choose summary. Is there anyway to do this?

Thanks

 

[xlbo]

Not if you are using a subreport - all data for a report (including sub reports) is run when you execute the report

Only way around this I have found is to have a "drill through" button which runs the detail section on its own using the navigation property of a text box

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question