SQL Server Performance Forum – Threads Archive

Conditional execution of dataset??

I have a report which contains 90 datasets.
They correspond to various rectangle regions displayed in the report. The visibility of the rectangle regions can toggled by a flag parameter that i will send as a parameter to the report. It so happens that i might want to display only a limited number of rectangles, making the others visibility=false.
Unfortunately i think that the datasets filling the data regions will execute even if the regions are themselves not visible. Is it possible for me to NOT execute the datasets which i know are filling those regions which are not being displayed by me?? Appreciate any help on this.
Thnx

---

]]>