Post reply

Performance of Reports

  • May 13, 2010 at 6:12 am

    #1166788

    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

  • May 13, 2010 at 6:23 am

    #1166790

    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...

  • May 13, 2010 at 6:30 am

    #1166795

    is the report generated by these parameters related

    Raunak J

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

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