CODEWITHSUNDEEP
reporting-servicesssrs-2008
user3752500
user3752500

Reputation: 57

ssrs specific value true/false/all

I have a parameter @ResourceSatus, which should has 3 options: true/false/all. It works well with true/false, but when i add "all" it doesn't show anything. I use filter as explained in this post: SQL Reporting Services Boolean Parameter (True/False/All(?))

I don't understand what should put for ObjectFieldName.Value. Appriciated for answers

Upvotes: 0

Views: 2788

Answers (1)

Steven V
Steven V

Reputation: 16595

=IIF(IsNothing(Parameters!parmTRUEFALSE.Value), ObjectFieldName.Value, Parameters!parmTRUEFALSE.Value) is the code from the other question.

ObjectFieldName is just the name of the object you would want to display if IsNothing(Parameters!parmTRUEFALSE.Value) equates to true. If you're pulling from a database field named Example, ObjectFieldName would be replaced with Fields!FirstDegreeYear.Value.

Upvotes: 1

Related Questions