CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-tablix
Sormita Chakraborty
Sormita Chakraborty

Reputation: 1055

SSRS column background color formatting not working

I have the following requirement: A column has negative values and NA values as well. The negative and NA value cells should be "Red" and other cells should be "light grey". I have written the following expression for this:

=IIF(Fields!BaseDOS.Value ="NA" OR Fields!BaseDOS.Value < 0, "Red", "LightGrey")

But it is not working for NA fields. Also I am using expression to show the negative values in parentheses:

=Format(Fields!BaseDOS.Value,"##0.00;(##0.00)")

This is also not working. Please help.

Upvotes: 0

Views: 578

Answers (1)

BIDeveloper
BIDeveloper

Reputation: 2638

You should really post each problem as a separate question.

In the background color property for the text box try:

=IIF(Fields!BaseDOS.Value ="NA" OR Fields!BaseDOS.Value < "0", "Red", "LightGrey")

BaseDos must be a string.

In the format property for the textbox you want to show parenthesis try:

#,##0.00;(#,##0.00)

Upvotes: 2

Related Questions