Skip to Content
0

crystal report cross tab background color

May 03, 2017 at 07:36 PM

24

avatar image

I have a table that looks like this

category | number | month year | Color
-----------------------------------------------------
All      |  0.25  | YTD 2017   | 
Apple    |  1.23  | MAR 2017   | 
Orange   |  1.10  | FEB 2017   | 
Orange   |  3.33  | YTD 2017   | green
Apple    |  2.20  | FEB 2017   | 
Apple    |  1.11  | YTD 2017   | red

I want my cross tab to look like this

       |FEB 2017|MAR 2017|YTD 2017
-------------------------------------
Apple  | 2.20   |  1.23  | 1.11 (I want this cell to be red)
Orange | #.##   |  #.##  | 3.33 (I want this cell to be green)
All    | #.##   |  #.##  | #.##

what I have done so far is to have Color in the summarized fields.

it shows up the value as text. but I can't color it ... this is the formula for crosstab background color

if {table1.SColor} = "Green" then crGreen
else if {table1.SColor} = "Orange" then crRed

screenshot of current state. enter image description here

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
May 04, 2017 at 08:54 AM
0

Hi Bob,

Do you want rows in the two YTD columns to be colored?

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded