March 1, 2010 at 8:16 am
Hi,
I used SSRS 2005 to create a report. This report requires 3 parameters. Parameter3 will accept new value from Parameter_Name for retreiving new list of result.
1. Parameter1 : Select P1 From Table1
2. Parameter2 : Select P2 From Table2
3. Parameter_Name : [new typing from user ]
4. Parameter3 : Select P3 From Table3 WHERE Name = @Name : where @Name is passing from Parameter_Name.
Everything works fine as I expect.
Here is my concerning. When the report first load, Parameter_Name defaulted to blank. And all three select statements are fired and retreived result. When I changed the value for Parameter_Name, Parameter3 gets fired which I want the new result list for Parameter3. But why Parameter1 and Parameter2 also get fired. Is there a way to stop the Parameter1 and Parameter2 fired again when there is no need for a new list?
Because of refiring on all the parameters, this slows down the performance on the report.
Any suggestion would be a big help for me.
Thanks,
March 1, 2010 at 8:22 pm
you'll probably get more answers to this question in one of the five different SSRS forums, here: http://www.sqlservercentral.com/Forums/Group416.aspxp
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 2, 2010 at 7:04 am
Thanks,
I will look into those.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply