Change Backcolor when date changes 2

[Sammy145]

Im using Crystal reports 11
and SQL server 2000

I have a SP in SQL that group all my result by data and category,The report accepts 2 date params
eg
04/07/2005 HOME
04/07/2005 ORANGE
04/07/2005 GOLD
05/07/2005 hello
05/07/2005 BYe

Now can I change the backcolor when the data changes so say 05/07/2005 by default all the report is white but change it to sky blue.


Thanks

sam

 

[Naith]

Conditionally format the colour of your section with

if remainder(groupnumber,2) > 0
then nocolor
else color(200,225,250)

 

[lbass]

Create a running total {#date} that chooses distinctcount of {table.date}, evaluate on change of group (date), reset never. Then use a formula like:

if remainder({#date},2) = 0 then crBlue else crNoColor

//or use Naith's color(R,B,G) value

-LB

 

[Sammy145]

Thanks guys worked like a charm

sam