create a banded report if the ticket number changes 2

[CrystalizeCanada]

Hi there,

I'm trying to conditionally format my details so that if the ticket number changes then the record will change to silver. So I end up with a banded report. Silver/white/silver/white etc.

My report is sorted by ticket number and tickets can be listed more than one time. For e.g.:

1 this is ticket 1
1 this is ticket 1
2 this is ticket 2
3 this is ticket 3
4 this is ticket 4
4 this is ticket 4
5 this is ticket 5

I would like ticket 2 to be silver, 3 to be white, 4 to be silver, 5 to be white etc.

Any help would be greatly appreciated.

Tx


Gordon BOCP
Crystalize

 

[CoSpringsGuy]

try

if remainder({ticketnumber},2} = 0 then crsilver
else nocolor

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[CrystalizeCanada]

Thanks very much for you reply.

Except I have some missing numbers and on those I notice it doesn't work. So my example wasn't 100% correct.

I can have tickets 1,2,3,4,5,9 for example and 6 7, 8 are not in the database so it throws off the math unfortunately.

Any ideas?

Tx


Gordon BOCP
Crystalize

 

[CoSpringsGuy]

if there is a chance that a ticket number may be skipped the above wont work so another way would be to create a running total.

field to summarize is ticket number
distinct count

evaluate for each record

reset never

in the color section of section expert use this formula
if remainder({runningtotal},2) = 0 then crsilver else nocolor




_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[CrystalizeCanada]

Very clever.

Works perfectly

Gordon BOCP
Crystalize