SQL Server Performance

Conditional execution of dataset??

Discussion in 'SQL Server Reporting Services' started by addytude, Nov 16, 2004.

  1. addytude New Member

    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

Share This Page