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.
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”.
Tags: #SQLServer, SQL Server, SSRS EXPERT, BI, #BI,