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