Search code examples
sql-serverreporting-servicesssrs-2008ssrs-2012

SSRS Shared DataSet with Parameter

I have an SSRS Project that will have 5 reports (*.rdl files). All reports will output the same data, the only difference being "ClientName" in the WHERE Clause.

So I created a Shared Dataset in my project. Inside that shared dataset, I added a parameter @ClientName.

In my report (*.rdl file), I added a dataset that referenced my shared dataset. How do I make this dataset sent a hard coded value for "Client Name" to the shared dataset so it doesn't prompt the user to enter one?

Solution

  • Add a parameter to your rdl as well, turn the parameter visibility off and set the default value to the static client name (ie default="Fred"). When the SSRS report runs, it should pass the local parameter with the default value to the shared dataset without the end user having to select or enter a value.