Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: coloring a crosstab field based on some conditions Post Reply Post New Topic
Author Message
otto
Groupie
Groupie


Joined: 17 Mar 2014
Online Status: Offline
Posts: 53
Quote otto Replybullet Topic: coloring a crosstab field based on some conditions
    Posted: 11 May 2015 at 7:41am
Is there a way to color a crosstab summary field based on some conditions. I tried on Highlighting Expert but cannot perform an OR. Tried also on Format Field/Font but not able to see the summary field.

Any idea on how to solve this?

Thanks
IP IP Logged
Erik
Groupie
Groupie
Avatar

Joined: 05 Dec 2013
Online Status: Offline
Posts: 50
Quote Erik Replybullet Posted: 18 May 2015 at 7:19am
Right click on a field in the Cross-Tab, choose "Format Field" or "Format Text", and go to the "Border" tab. There is a checkbox for "Background" which you can enable for background color shading.

From there, click the x-2 icon to create a formula.

You can use the formula to specify conditional background coloring, and the color codes are provided there by default in comment form.

Here is one I've used:

if {Command.Image Difference} = 0 then crLime else crRed

I am not aware of a way to conditionally format the foreground text color


Edited by Erik - 18 May 2015 at 7:57am
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.016 seconds.