CODEWITHSUNDEEP
reporting-servicesreport
B.Avramov
B.Avramov

Reputation: 67

Why my parameter shows me an error Failed to evaluate the FilterValues of the DataSet?

I want to get available values from query in my ssrs report parameter. I set Get values from a query 

DataSet : name of my dataset#

Value field: my field

Label field : my field

To get an idea i will show you what i mean: enter image description here

enter image description here

enter image description here

For expected results : I want to use my parameter as multie value parameter..

Upvotes: 0

Views: 803

Answers (1)

AnkUser
AnkUser

Reputation: 5531

Your expression should be something like this and you need to add this expression by pressing fx next to value rather than directly adding it.

=IIF(Parameters!RootPoint.Value(0)="",Fields!C_RootPoint.Value,Parameters!RootPoint.Value(0))

also if you are trying to check if your first parameter value is null then you should try like below

=IIF(Isnothing(Parameters!RootPoint.Value(0)),Fields!C_RootPoint.Value,Parameters!RootPoint.Value(0))

Upvotes: 1

Related Questions