how to give background color of a certain row of crystal report

[sajankk]

hi all,

i would like to know how can i give background color for certain row of a crystal report.
eg: - if am taking monthly report i would like to make some background color for the day sunday(holiday). how can i get it

saj

[zeezee]

You can do it by using a formula to set the background color of Details section. You have to do this in crystal reports.
Whats your version?
In your design view, right click on the section - Details - and select Fromat Section.
In Format section , there will be two tabs, choose Color tab. in there , you will see a background Color selection. There will be button to insert Formula for backgorund color. You can use that.
BTW, you should post this in Reports Forum, ask a Moderator to move it there.

[zeezee]

Here is some Screen Shot also

The Format Section Window



The Forumla Editor


The given Formula in the Image gives the sunday.

If  (DayOfWeek (MyDateField)) = 1 Then
  crRed
else
  crNoColor

Change MyDateField to appropriate Field in your report. And the Change the color to your needs. There are Color Constants you can use in the Functions List, the middle one, in the Formula Editor. Use That.