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

Change Backcolor when date changes 2

Status
Not open for further replies.

Sammy145

Programmer
Oct 4, 2002
173
GB
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



 
Conditionally format the colour of your section with

if remainder(groupnumber,2) > 0
then nocolor
else color(200,225,250)
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top