Conditional Formatting on a Formula in SQL Reporting Services 2008
Posted on 2011-05-04
I have a field containing a formula. I know that SQL Reporting Services offers conditional formatting, where you can have a field display as Red when the field is less than 0. But, how do you do that when the field is a formula?
Here is the formula:
This formual is a sum based ono a grouping.
I went into the Placeholder properties and then in the Font section and clicked the function button. Then, I entered the following:
Fields!XTNDPRCE.Value))) < 0, Red, Black
But,I got an error upon running the report with this.
How do you do this conditional formatting when there is a formula. I know that this would work with a regular field.