Need help to one defect on SSRS report for refresh parameters. Below are some steps I performed.

1. Select report

2. Select range of dates

3. Enter Guest Last Name "Cooper"

4. Use PDF Export command button

5. Pdf is generate properly.

6. Press Clear Command button, its Clear all the text box and reset the drop down and date picker control.

8.  Select range of dates.

9. Select "View in browser"

Here is the problem the last name parameter keep the value from earlier selection and Cooper" will shown when we view the report.

Because of above issue my report is not working properly..  I have check the parameter with Automatic Refresh & Always Refresh Option but not succeed. I have checked with IE as well as Chrome.

Is there any kind of setting required on parameter or server side?

Any suggestion would be greatly appreciated!  Thanks!

Anand

Hi Anand,

Are this parameters all dependent on each other ?? if yes then that might be the issue  getting the  default selection.

 This is because  When you change the value of the upstream parameter, SSRS will rerun the query for downstream datasets. The downstream dataset (for parameterGuestName) will return Cooper and Cooper as values. Since parameterGuestName is already set to Cooper , the parameter will remain as it was. If you click the parameter dropdown you should see that other guestnames can be selected.

If you want it to reset parameterGuestName everytime parameterDateRange is changed then you will have to make the parameterGuestName values unique for each parameterDateRange value. You could do this by prepending the parameterDateRange value to the parameterDateRange value in your dataset. So, instead of:

eg:

----

DateRange|| GuestName

14/07/2008 Cooper

This should be 

DateRange|| GuestName

14/07/2008  Cooper14/07/2008

This will solve your issue for sure :)

Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.

Hi Anand,

According to your description, the parameter @GuestLastName keeps the value from the earlier selection to filter the report, right?

In your scenario, please check if you have specified any default values for the parameter @GuestLastName. Also please check if you have useed a cache refresh option to create schedules for preloading the cache with temporary copies of data for a report. If that is a case, please disable or delete the cache refresh plan. For more information, please refer to this article: Cache Refresh Options (Report Manager).

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

If you have any feedback on our support, please click here.