• Hi Pete,

    I have a specific problem that I'm trying to solve and based on your post you may have faced this same situation.

    I have a report with a very similar design as your Patient Profile report. Meaning that in a single report I have several tables each with it's own stored proc. The tables are logically grouped into modules and I allow the user to choose which modules they want to see via checkboxes that hide or display the associated module. My issue is that when the report is executed it runs ALL modules in the background but only displays the one the user selects. So if the user choses to view say module 2,5, & 7 only those modules will display to the user but the report is still executing the stored procedures for all modules in the background. Performance is good but clearly it would be ideal if only the selected modules are executing their associated stored procedures instead of all modules executing all stored procedures every time. I'm trying to figure out if it's possible to only execute the selected modules (conditional execution) but I haven't found a straightforward way to make this happen.

    I would love to hear your thoughts or experiences with this situation.

    thx!