Report parameters: "All" value should not filter data

[Christophe]

I have a report parameter named "Trained" with the following values:
- All
- Trained
- Not trained

The problem is that I can not have a parameter value that does not filter ("All").

At the moment, the filter applied on my tab is as follows:
Expression: =Fields.ResourceTypeTraining (that is a boolean, true if trained)
Operator: =
Value: =(Parameters.Trained.Value Like "Trained" )

If the user selects "All" value, obviously only the "not trained" data will be displayed.

I have tried many solutions, with "Allow null" for example, but I still do not obtain what I want. Is there a property or something else that could fix that?

[Nasko]

Hello Christophe,

To solve this issue you can use the following expression in your report filter:

Expression:   =Fields.ResourceTypeTraining
Operator:   =
Value:   =IIf(Parameters.Trained.Value = "All", Fields.ResourceTypeTraining, Parameters.Trained.Value)

Let me know whether the proposed solution helps.

Regards,
Nasko
Telerik

[Christophe]

It works perfectly, except that you cant compare bool and string, so it worked well with =IIf(Parameters.Trained.Value = \"All\", Fields.VolunteerTrained, IIf(Parameters.Trained.Value = \"Trained\",1,0))

Thank you !