Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

alternate row or group shading

Status
Not open for further replies.

mart10

MIS
Nov 2, 2007
394
GB
I am using CR 11

How can I place shading on every other data row OR group please
 
This may work for you....

If remainder(recordnumber,2) = 0 then crsilver else crNoColor
 
In the detail section expert click on the color tab and then the x+2 and enter the following

If remainder(recordnumber,2) = 0 then crsilver else crNoColor
 
No I have been trying this. The problem is the Group no. i have several group and also I only show the maxium record within a group. I I drop the group no into the report and take a look I can get data such as follows :

1
2
8
11

But I want to alternate the colour so 1 and 8 to grey for instance and the example I give is just random so I cant purely decide the colouring based upon this group no
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top