SSRS Shared DataSet with Parameter

Question

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?

Answer 1

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.

Answer 2

If you want to hard code the value, you can add it as the Parameter Value in the Dataset's Parameter tab.