i have alist report and i waana show the every third row of the list report grey .. according to the picture .. plz rply wth all possible steps remember that is is sectioned at location
Add a Query Calculation to your query, call it something like 'GreyRows'.
You can use 'running-count' on one of your data fields to get a count of how many rows have appeared since the last subtotal for that item.
Then use the 'mod' function to test if you have hit a 3rd row.
so something like this: mod(running-count([Location]),3)
That data item will now have a '1' in it whenever you want to highlight the row.
Now on your Report Page, highlight the list column body area wherever you would like the Highlighting to apply, select 'Conditional Styles' -> Advanced Conditional Style.
Name it 'Highlight 3rd Row'. Click the button in the bottom left to create a new condition, and edit the new condition and select your 'GreyRows' data item, and test it against 1.
ie. [qryMain].[GreyRows] = 1
Set the style on that condition to Background color gray.