I have a report that has many datasets that populate different tables. Depending on an ID tables are being shown or hidden. The issue we have is regardless of the show/hide the stored procedure for that table runs against the server. We have 10 datasets for one entity and have this set up to run for thousands of entities at a time, creating a lot of overhead on the server. Is there a better way to do this so, for instance if table 4 is the only data needed then ONLY that SP is run?
Any help is appreciated here, been banging my head against the wall for too long.