CODEWITHSUNDEEP
t-sqlreporting-servicesreportssrs-2008bids
John Smith
John Smith

Reputation: 187

Indicators in SSRS

I have a column in SSRS report. The value is "True" or "False" or "Yes" or "No" or "1" or "0"

Instead of showing that in that column, I would like to use indicator.

I placed indicator in that column but need to set start and end property. How do I go about doing it so I can show green checkmark when it's "True", "Yes", or '1" and red otherwise?

I am trying =IFF(Fields!Column_name.Value = "True", "Red", "Green") for the Start value for Green Check mark...but obviously I am wrong...

any help?

Upvotes: 0

Views: 7014

Answers (2)

Jason MacDonald
Jason MacDonald

Reputation: 109

Go to the Indicators properties > Values And States and put the Check's Start & End Value to 1. And the X put it's Start & End Value to 0.

Then write your expression like this:

=iif(First(Fields!YourField.Value, "YourDataSet")=True,1,0)

That should give you a Check if checked or an X if not.

Upvotes: 1

King
King

Reputation: 339

Well maybe its just a typo in your question but a couple things stand out

  • the function is IIF, not IFF
  • The True result should come first after the condition

I've never used the indicators before, but looking briefly at them, it looks like you can define ranges that are acceptable (green), unacceptable(red), or in the middle (yellow).

Start and End should probably be numeric values, "Green" and "Red" don't seem like valid values.

Try binding the indicator value expression to something like this.

=IIF(Fields!ColumnName.Value = "True" OrElse
    Fields!ColumnName.Value = "Yes"  OrElse
    Fields!ColumnName.Value = "1", 100, 0)

Upvotes: 2

Related Questions