question

xnl28 avatar image
xnl28 asked

Prevent report disappearing when parameter changed

In one of my SSRS reports, the report that was previously displayed disappears. This is undesirable. These are the steps to reproduce the issue : - User navigates to the report and selects some parameter values and clicks View Report. - Report displays correctly. - User then selects another of the possible values for parameter @Supplier **but does not click View Report**. - The report that was previously being displayed disappears and the user sees a blank page. Here are some relevant points about the parameters: - Parameter @Supplier's advanced options is set to Never Refresh. - Parameter @Supplier is Text, is not multi-value, and gets its available values from a dataset - The dataset for Parameter @Supplier depends on value of another parameter, @Country - None of the other three parameters depend on @Supplier Does anyone know how to prevent the report from disappearing like this? If the user selects another value for the @Supplier parameter, then the report data should either: 1. not refresh until the user clicks View report, or 2. refresh with the newly selected parameters (i.e. same as if the user clicked View Report)
sql-server-2008-r2ssrs-2008parameters
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
I am guessing that the value in the parameter that is being changed is actually a value for the dataset that provides data to a second parameter, therefore when the 1st changes the second on needs to refresh to get its options. This would have the effect of refreshing the report too, sadly. I think the only option would be to separate the 2nd parameter's reliance on the 1st.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

xnl28 avatar image xnl28 commented ·
The parameter @Country is used in the dataset to provide the list of values for parameter @Supplier. The value of @Supplier selected is then used in the dataset for the tablix. I have tried changing the @Supplier dataset so that it does not depend on @Country, but still the report disappears when selecting a different value. This is in contrast to other report parameters which I can change without the report disappearing. These other parameters get their values from a hard-coded list in "Specify Values".
0 Likes 0 ·
David Wimbush avatar image
David Wimbush answered
When you say 'undesirable' do you mean it gets on your nerves or that users are actually complaining. I did have one user who complained about it. I had a look but couldn't see how to prevent it so I told him SSRS does that so you can't accidentally think you're looking at the results with one parameter value when they're actually the results with another value. He thought that was a great feature. (I don't *think* this makes me a bad person:)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.