Skip to content
July 22, 2013 / Rodrigo Chiolas

SSRS – Disable auto update of parameter datasets


In SSRS 2008 and SSRS 2008 R2, changing the main dataset wiht Report Designer overwrites the parameter datasets, which will erase any customization you’ve made.


Right click the report and choose View Code.

Find the parameter dataset  and modify it.

Add the line


Like this:



<CommandText> …




Finally, don´t forget to save.


Here is the original post used to solve this issue: Original Link


One Comment

Leave a Comment
  1. John / Jul 23 2013 10:59 am

    Good Word

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: