Performance of Reports

  • Hi All,

    I want to know how one can increase the performance of a report.

    in my report i will be passing nearly 10000 ids to the parameters.

    this happens in the main report. however, my subreport will show data for only one id at a time.

    i am passing fields!id.Value to my subreport hoping this would increase its efficiency.

    can i do anything else to increase its performance?

  • Hi Malavika,

    I would suggest you to introduce multi parameter report and optimize your underlying dataset SQL query on the basis of parameter selection using the IF/WHERE or CASE clause.

    Raunak J

  • thanks for the reply .

    yes i have written a IF statement to check for ALL or specific value condition in my SP.

    also, i am using the joins and as i told above i am passing the fields of the report as parameters instead of assigning them the values of master report parameters.

    these will help increase performance rite? my worry is it is loading 10000 parameters....

    and it is multi-valued...

  • is the report generated by these parameters related

    Raunak J

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply