Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: conditional format of a box Post Reply Post New Topic
Author Message
ScubaVal
Newbie
Newbie
Avatar

Joined: 09 Mar 2007
Location: United States
Online Status: Offline
Posts: 12
Quote ScubaVal Replybullet Topic: conditional format of a box
    Posted: 02 Aug 2007 at 11:27am
I have a rounded box on my report that my boss wants to change color based on a field.  I found conditional formatting on a field, but I don't know if I can apply it to the box. 
 
My boss is very visual and wants the box!  HELP!  He's waiting now for me to do it Confused
try it... if it doesn't work, google it
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 02 Aug 2007 at 2:09pm
Unfortunately, there doesn't appear to be any way to conditionally format boxes.  I'm not even seeing a way to conditionally suppress them, which would be a way of working around this.
 
-Dell
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 02 Aug 2007 at 9:53pm
This might be crazy, but what about creating multiple sections with a different box in each. Then conditionally disable the section that you don't want to use? If you have a lot of fields this would be a pain. Another idea (which I've never tried before but it just came to me) is to only put the box in its own section. Then turn on Underlay Following Section for the main group. This would effectively make the correct box appear with the rest of fields and you wouldn't have to repeat the entire section each time.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 02 Aug 2007 at 9:54pm
Ok, forget that idea. Put both boxes in the same section with one on top of the other. Then used conditional formatting to hide the one you don't want.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
ScubaVal
Newbie
Newbie
Avatar

Joined: 09 Mar 2007
Location: United States
Online Status: Offline
Posts: 12
Quote ScubaVal Replybullet Posted: 03 Aug 2007 at 12:50pm
Thanks to all for answering.... I talked him into allowing a colored bar instead of the dang circle.  I used highlight for the different values (only 3 at this time).
 
It's a shame that a graphic can't be conditionally formatted.  Oh well. 
try it... if it doesn't work, google it
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.