how to give background color of a certain row of crystal report
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
Re: how to give background color of a certain row of crystal report
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.
:wave:
2 Attachment(s)
Re: how to give background color of a certain row of crystal report
Here is some Screen Shot also
The Format Section Window
http://www.freeimghosting.com/images...4187639974.jpg
The Forumla Editor
http://www.freeimghosting.com/images...4187639290.jpg
The given Formula in the Image gives the sunday.
Code:
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.
:wave:
