Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Conditional Sub-Report

Author  Topic 

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2007-07-19 : 17:54:18
I have a very large report for invoices (totals 900 pages)



This already takes up to 10 minutes to generate, and now I need to add more functionality into the report.


I need a conditional sub-report.


For instance, I need the sub-report not to generate if (first(myfield.value) = 1).


I know I can conditionally hide the report, but is there anyway to conditionally skip the sub-report from generating. The reason is when you are generating 900 pages, it's very slow as is, and I do not want to make it any slower.


Thanks
   

- Advertisement -