Dynamically color to each column in Cross-tab report

[Former Member]

Hello All,

I am a newbie in Crystal report,from last few weeks, i am working on cross tab crystal report.i have a requirement to show color dynamically for each column.i am adding an attachment how i want it. i tried dynamic coloring using object field formula but it is showing red color to all data.i want red color data when in 2nd  cross tab report data is beyond upper or lower limit in first cross tab table. it will be very helpful if somebody will give me any clue on this.... i read so many articles now it seem like impossible for me..:(

i am using visual studio 2010 and sap crystal report version 13.0.0.99 for visual studio 2010.

[Former Member · Accepted solution]

Hey Guys,i don't know whether it is possible or not. you people have experience in sap crystal report.if you think that it is not possible then please let me know. because after getting response only,i can talk to my management that what they are asking its impossible. at-least give response whether its positive or negative.

[abhilash_kumar · Accepted solution]

Hi Manish,

This is not impossible to do however it is not the easiest thing to do either.

Would there always be five clients?

If yes, then you should consider creating a manual crosstab. If not for a manual crosstab, it gets very difficult to compare each value in the crosstab with a corresponding number that is not part of the crosstab - in this case the upper and lower limits.

-Abhilash

[former_member205840 · Accepted solution]

Hi

When you create a cross tab it groups the values according to column and row, now how can we related two cross tab groups and write a condition to change the color ?

It is not possible to achieve this through cross tab, but you can create a standard report in cross tab style i.e. mock cross tab.

Here we can refer / use other values to change the color of values.

Example :

If {Client} = 'Client1' and ({Value} < {LowerLimit} or {Value} > {HigherLimit}) Then CrRed Else CrNoColor

-Sastry

[Former Member · Accepted solution]

hi Abhilash,

my cross tab has also dynamic column which can be increased and decreased.with  my second cross tab my first cross tab will also do same behavior. i cannot fix column numbers as  requirement. if any other way is there then please let me know...