CrossTab report in CR10 in visual studio2005

[2328]

I created a crosstab report using CR 10 built in Visual studio 2005, in my report summary field based on some conditions , the back ground colors(crgreen,crred,ceyellow etc) should change.



when I see the output it shows all cross tab summary fields as just black color .
any suggestions

Thanks

 

[lbass]

Is this a continuation of a previous thread? You will have to tell us how your crosstab is set up, row, column, summary, and then show us the formula you used to try to change the color.

-LB

 

[2328]

Thanks for your interest

I don't think its continuation as client changed is mind that he wants to use CR 10 built in VS 2005.
Previous I used CR XI.
Those threads are differnet , this thread is completely on CR with VS.

I am doing a cross tab report.
I have to get status of each metric under one facility
So my row is facility ,
column is Metric and
summary is status color
Based on dates I wrote a
case when ... then crRed
else..
cryellow
else .... crgreen etc END
and I concatnated above result with another field ratio.
it looks like this
crRed0:0
crGreen3:4
crYellow1:2



In summary I am geting text , In crystal I wrote formula for back ground color

IF CurrentFieldValue like '*crGreen*' then crGreen
ELSE IF CurrentFieldValue like '*crRed*' then crRed
ELSE IF CurrentFieldValue like '*crYellow*' then crYellow
ELSE IF CurrentFieldValue like '*crWhite*' then crWhite

and even I changed to crRed to color(255,0,0)
Even though the output looks me all black , even I took print out on color printer.

I can't use highlighting expert as I don't know what is summary field value as highlighting expert does not support like condition.

Once again thanks

 

[lbass]

Where did you put the formula? I just tested this and it worked perfectly.

-LB

 

[2328]

Thanks Lbass,
I placed the formula, in Fotmat --> back ground,
Then I came to know , they are matching with different DB,

Now I got the out put ,

only the alternate row colors left out

I have 2 columns like
ID Name
1 Srinivas
Sam
John
2 LBass
Dave
3 Tektips
thanks

Now I have to get alternate rows in some color
like Sam, Lbass,Tektips should be colored

I seen exsiting threads , but I didn't worked for me,

Once again thanks lbass

 

[lbass]

You are responding to the wrong thread. The alternate row color method does not work well when there are multiple row fields.

-LB

 

[2328]

Thanks for every one. Especailly Lbass