Home > SSRS Expert > SSRS #64 – Remove default values for parameters on report server

SSRS #64 – Remove default values for parameters on report server

In my previous blog, SSRS & SSAS #63 – Stop SSRS 2008 MDX Query Designer from Overwriting Parameter Queries, I mentioned that you can manually remove the parameter default values in BIDS before you deploy your reports to your report server.

But what if you already “infected” your report server” with unwanted default values for report parameters? It has happened to me many times. So I thought I should share with you this little annoying thing about default values for parameters on report server.

Here is a screenshot from the report server showing the unwanted default values.

image

Talking about unwanted or unwelcomed guests, this is one of those. It will stay on the report server, unless we take time to remove them.

Simply uncheck the box “Has Default”.

image

Categories: SSRS Expert
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: