Hello,
I have a report (in Q3 2013 version) with several datasources and parameters. Some of those parameters are binded to datasource.
When I run the report in our web application I can see in MS SQL server profiler that binded datasources are run multiple times. Some of them like 40 times during the rendering.
Did I miss something important about the rendering procedure that can cause such a behavior? I did not find any pattern, jsut that only datasources that are bidned as sources for parameters are affected. But I was not able to find a pattern.
Thank you for your advice.
J.H.
I have a report (in Q3 2013 version) with several datasources and parameters. Some of those parameters are binded to datasource.
When I run the report in our web application I can see in MS SQL server profiler that binded datasources are run multiple times. Some of them like 40 times during the rendering.
Did I miss something important about the rendering procedure that can cause such a behavior? I did not find any pattern, jsut that only datasources that are bidned as sources for parameters are affected. But I was not able to find a pattern.
Thank you for your advice.
J.H.
1 Answer, 1 is accepted
0
Hinata
Top achievements
Rank 1
Rank 1
answered on 12 Sep 2014, 02:05 PM
Hello Jan,
This might happen if you use cascading report parameters and is unavoidable due to the way data has to be retrieved.
In any case 40 times sounds like a lot, so it may be useful to attach a sample which someone can review and advise.
This might happen if you use cascading report parameters and is unavoidable due to the way data has to be retrieved.
In any case 40 times sounds like a lot, so it may be useful to attach a sample which someone can review and advise.