SQL datasource enumerated multiple times when the report is rendered

2 posts, 0 answers
  1. Jan
    Jan avatar
    5 posts
    Member since:
    Sep 2014

    Posted 09 Sep 2014 Link to this post


    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.


  2. Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 12 Sep 2014 in reply to Jan Link to this post

    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.
Back to Top