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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to show one line in white and other in silver 1

Status
Not open for further replies.
Aug 13, 2009
29
US
Friends I have a small question,
My sample data is like this
just one detai section and one group.
IN detail section my data is like this
OLD new
own field1 field2
rent field2 field3
buy field4 field5
other field6 field7

How can implement that one line is in white that is Own colum will be in white and Rent colum will be silver alternatively,any ideas?
Thanks a lot.
Lori
 
One way would be in the Section Expert, Color Tab, use the formula button (x+1) and have the formula decide the colors.

Something like this:

IF {CLIENT.CID} like "1*"
THEN crSilver
Else
(IF {CLIENT.CID} like "2*"
THEN crYellow
Else
(IF {CLIENT.CID} like "3*"
THEN crFuchsia
ELSE crWhite))
 
thank you so much for quick response, but here I dont have any common field among different lines, everything is in same detail section with different fields.
 
Right click the details section and select 'Section Expert' then 'Color' Click the 'X-2' button and enter:

Code:
If remainder(recordnumber,2) = 0 then crSilver Else crNoColor
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top