hi,

how I could create an optional parameter respectively enable the selection of null-parameter? Picking the Null-value-box when creating report parameters is not sufficient.

Hi,

I have already implemented report parameters in reports.I generally use report parameters to filter (=limit) the report data. So this is nothing completely new for me.

But now the users have asked for an option to implement optional filter parameters: they want to have multiple filter criterias, but do not want to have the need to apply all filter parameters in one report. They would either pick the value from parameter A or parameter B.

As the surface of "report parameters" showed me the option "Null value" and "empty value" I hoped to implemented this feature by picking one of these boxes. But no change! I've already tried several workarounds.

Now I hope that you can show me one solution to do this.

Thanks.

I was using a dataset instead of free text entries.You may say that when using a dataset query my data do not contain any Null values? This is not the case: the dataset contains NULL and I can choose this value.

But how to continue? When I now select the "Null"-Value in my report parameter I get a report with no data results. This is not the intentition that I had: I just wanted to optionally apply the filter.

Hi,

Sorry that my post was quite misunderstanding. I think that your solution meant something else.

Essentially I need one filter-parameter that should be implemented as an optional report parameter. This means: the user can pick one filter criteria from a drop-down list - but does not have to. 
(Reporting Services seemed to provide this feature as you can pick the null-value and empty value box in the user interface for creating the report parameters.But in reality it had no effect on the output: I always had to pick one parameter and so my choice was not optionally.)

So this solution does not seem to work. But I chose another way: I integrated one "Null"-Value into my filter parameter values. So the user can pick the null-value from a drop-down list.

Now I wanted to specify that: 
if my the null-value is choosen, all data will be displayed (no filtering!) and
if one of the other filter values are choosen, data will be filtered by the choosen value and displayed.

But I have no idea how to implement this. Do you have any idea how to do this? Or do you know any workaround?