I need peter to print red, paul to print blue, dave to print green 1

[andywing]

I can manage just the one field

if {myfield} = "peter" then red else nocolor

But how do I get multiples of the same in CR7 so that peter prints in red, paul prints in blue, dave prints in green etc.?



Andy Wing
Local Government - Systems Administrator
England

 

[dgillz]

if {myfield} = "peter" then red else
if {myfield} = "paul" then green else
if {myfield} = "mary" then blue else defaultattribute

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[andywing]

Many thanks dgillz

That works well

PS Extra thanks, your reply was posted within four minutes and it was just right first time!!!

Andy Wing
Local Government - Systems Administrator
England

 

[sewilj]

Andy

I'd advise you to adjust your ID and not mention the fact that you're working for local government. Lots of programmers don't like government of any sort.
I also work for local government and have been advised to change my ID just in case.




Lewis
United Kingdom

 

[dgillz]

Lewis,

Why change his ID? Is it considered "dangerous" in the UK to admit you work for the government?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[sewilj]

dgillz

Just passing on what somebody else advised me - a good deed for the day blown apart. I now feel like someone shot the messenger :-(

Lewis
United Kingdom