Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: custom background color Post Reply Post New Topic
Author Message
kirandb
Groupie
Groupie
Avatar

Joined: 10 Jun 2009
Location: United States
Online Status: Offline
Posts: 69
Quote kirandb Replybullet Topic: custom background color
    Posted: 14 Sep 2009 at 10:25am
I have to dynamically set the custom background color for every other row. I tried the following code in the formula editor for the bakground color.

if RecordNumber mod 2 = 0 then crCustom else crNoColor.
 
1)  It didnt work. DO I have name the custom color. If so how do i do it?
 
2) I have 3 detail sections which gets suppressed conditionally and all 3 sections have the above background color formula to display background color for alternate rows. My question is does this formula gets applied for each detail section or the entire report ?
 
Thanks,
Kiran
 
 
share your knowledge
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Sep 2009 at 10:38am
Place it on all 3 detail sections and replace the crCustom with either a color name or a RBG value
Examples:
if RecordNumber mod 2 = 0 then crSilver else crNoColor
 
if RecordNumber mod 2 = 0 then Color (236,242,242) else crNoColor
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.