Tuesday, March 2, 2010

Prevent SSRS Parameter Auto Postback

For some reason, the SSRS 2005 report that I’ve deployed on MOSS 2007 perform auto postback whenever a particular drop down parameter value is changed. It’s just a normal text drop down parameter with a default value. Some online post says not to use the “=SomeText” syntax, but mine is just the text directly set as the default value.

 

Luckily my colleague gave me the tip that the sequence of parameters might cause this behavior. Although there are no dependency between all my parameters, he advised me to put parameters that are dynamic at the top first, follow by the static ones at the bottom. That solved my problem!

7 comments:

Da said...

Did you have answers?

Zarko Radevic said...

Thanks a lot, this post solved my problem. Many thanks!

Regards

Anonymous said...

Top site, I hadn't come across sweechingho.blogspot.com earlier during my searches!
Keep up the good work!

Anonymous said...

Hiiiii, Sebast Here, I enjoy this joint I could definitely plant here.

Marlon said...

Also, make sure your parameter Field Labels are not ParameterCaptionIndented.

-Marlon

Anonymous said...

Hello,

I have a message for the webmaster/admin here at sweechingho.blogspot.com.

Can I use part of the information from this blog post right above if I provide a link back to your website?

Thanks,
Daniel

Swee Ching said...

Sure Daniel. It's meant to be shared.