Have Geek Brain

Dynamically changing parameter based on another in SSRS report

We have a report that in the 2005 version of SSRS, we could dynamically update one parameter (which is a textbox) from another report parameter (which is a dropdown). Each time the dropdown list changes, the text box will update. No problems. Now in 2008 this only happens the first time the report is viewed (in other words, the textbox is updated when the dropdown is displayed). If I change the textbox to a dropdown menu it works. But if I put it back in the textbox (i.e. I no longer set the available values ​​to none), the textbox is only updated the first time it is viewed.

Has anyone had this problem before? Please help.

Thanks.

+1


a source to share


1 answer


SQL Server 2008 SSRS does not always update every parameter in a report longer if it is not deemed necessary. When changing the parameter, there is a property under the Advanced → Refresh data parameter. The default is "Automatically detect when to update". For your situation, you probably need to change the parameter property to Always Update.



+3


a source






More articles:


All Articles