[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query… or can they?

Question

In the query designer drag a dimension on top of your report. Chose an Operator and a Filter and check the checkbox by Parameters and BOOOM you have your parameter. If you go now into your report designer you find the parameter you just checked in the folder Parameters on the left navigation pane (on top of the Datasets folder). Now open the folder an right click on your parameter for the properties.

You can set now a default value. If not the report opens and waits until a users selects a value from the drop down selection. After the selection the parameter gets passed to the query and the query gets executed and the report rendered.

Accepted Answer

In the query designer drag a dimension on top of your report. Chose an Operator and a Filter and check the checkbox by Parameters and BOOOM you have your parameter. If you go now into your report designer you find the parameter you just checked in the folder Parameters on the left navigation pane (on top of the Datasets folder). Now open the folder an right click on your parameter for the properties.

You can set now a default value. If not the report opens and waits until a users selects a value from the drop down selection. After the selection the parameter gets passed to the query and the query gets executed and the report rendered.