execution time of my stored proc is pretty fine. issues occurs in the report.
I have around 12 datasets that call the same proc. however, it takes substantial amount of time to load the report, this is because of the 12 datasets.
has anybody tried a way... that the data is generated once and stored in a table perhaps... (dynamically) and then all the datasets refer to the newly created table instead of calling the stored proc again and again...
or is there any other way ?