SSRS Sql2008R2

Posted on 2011-10-09
Last Modified: 2012-05-12
I am creating Sql reports using Sql2008R2.  I want to do the conditional row coloring based on
auto number field value. I want to display alternating row color based on auto number value.The report displays the auto number in ascending order.

Please let me know how to do this.


Question by:KavyaVS
    LVL 25

    Accepted Solution

    In the properties of table, you can check the value and add a conditional statement for the background colour..

    LVL 10

    Assisted Solution

    Here are two links

    SSRS Alternate row color

    SSRS alternate row color on group

    Hope that helps

    Author Comment

    I tried the below one.I am not sure what will be in the conditional check.
    =IIf(Fields!AUTONUMBER.Value="","Gainsboro","Transparent" )

    I want to do the conditional row coloring based on auto number field value.some rows have same auto number.Rows having same auto number display together.
    I want to change the row color whenever autonumber changes.

    Please let me know the conditional row coloring based on Autonumber value.
    I am not asking for alternate row color.

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (  This article explained how …
    How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 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

    22 Experts available now in Live!

    Get 1:1 Help Now