Cross Tab Formatting
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22401
Printed Date: 03 May 2024 at 8:47am
Topic: Cross Tab Formatting
Posted By: cbaldwin
Subject: Cross Tab Formatting
Date Posted: 27 Jul 2017 at 5:16am
I have a cross tab similar to the following example. The field in my header is {alphabet} and alphabet includes A,B,C and D. The {count}values in my crosstab are 2,10,20 and 15 respectivly for A,B,C and D.
A B C D
2 10 20 15
I would like to be able to format the {count}values in my crosstab based on the value itself (which i know how to do) but also on the value of the {alphabet} header.
For example if {alphabet}="A" and gridvalue<10 color equals red. and if {alphabet}="B" and gridvalue<5 color equals blue.
I know how to set the colors based on the gridvalue. I am not sure how to appropriately reference the value of the crosstab header {alphabet} and make the formatting based on the two values.
Thanks in advance for any insight.
CJB
|
Replies:
Posted By: DBlank
Date Posted: 27 Jul 2017 at 5:28am
maybe this?
http://crystalreportsbook.com/Forum/forum_posts.asp?TID=11213
and also search help (or this forum) for GridRowColumnValue
|
Posted By: cbaldwin
Date Posted: 27 Jul 2017 at 6:04am
Thanks i will investigate your suggestions.
|
Posted By: cbaldwin
Date Posted: 27 Jul 2017 at 9:19am
Exploring GridRowColumnValue ultimately led me to a perfect example of what I was seeking.
GridRowColumnValue (groupAlias, (optional) row/columnIndex)
I did have some problem trying to determine what to use as the groupalias for the column but i found that on the Cross Tab Expert-Customize Style Tab under "Alias for formulas"
Thanks for the help
|
|