Conditional Formatting on a Formula in SQL Reporting Services 2008

Posted on 2011-05-04
Last Modified: 2012-05-11

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.


Question by:apitech
    LVL 22

    Accepted Solution

    Fields!XTNDPRCE.Value)) < 0, "Red", "Black")
    LVL 1

    Author Comment

    LOL!  I didn't think about the placement of the parentheses!

    You're right, as usual!

    Thank you, Nicobo, for getting me out of yet another debacle!!!

    LVL 1

    Author Closing Comment

    Nicobo is an asset to Experts Exchange!

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
    Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now