SSRS Sql2008R2

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.

Thanks

KavyaVSAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
TempDBAConnect With a Mentor Commented:
In the properties of table, you can check the value and add a conditional statement for the background colour..

 <BackgroundColor>=iif(Fields!<FieldName>.Value="<ConditionalCheck>","Silver","DarkSalmon")</BackgroundColor>
0
 
itcoupleConnect With a Mentor Commented:
Here are two links

SSRS Alternate row color

SSRS alternate row color on group

Hope that helps
Emil
0
 
KavyaVSAuthor Commented:
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.
Thanks.
0
 
KavyaVSAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.