Link to home
Start Free TrialLog in
Avatar of KavyaVS
KavyaVS

asked on

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

ASKER CERTIFIED SOLUTION
Avatar of TempDBA
TempDBA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KavyaVS
KavyaVS

ASKER

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.
Avatar of KavyaVS

ASKER

Thanks