CrossTab report(Alternate rows color when 2 field are there)

[2328]

Crosstab has row =x column=y and summary

In X 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,

Any help advance thanks

 

[lbass]

Try this solution: thread149-1166557.

-LB

 

[2328]

Hi Lbass,
Thank you very much , right now its showing alternate yellow colors, is there any way I can choose my own color.
Once again thanks

 

[lbass]

Change the rgb (red, green, blue) values in color(). I believe they can vary between 0 and 255, but I don't know myself what the combos are for particular colors. What color did you want to use?

-LB

 

[2328]

Hi lbass,
Thanks for your help, When ever I change any number in color, then its coloring all rows, not alternate rows,
I need a crpurle color for alternate rows.

And by any chance can I shade the first filed also.

Once again thanks
Srinivas

 

[lbass]

You have to change the color in both parts of the formula. Also, what do you mean by the "first field"?

-LB

 

[2328]

Thanks Lbass,
I really appreciate your response.
I changed both the places
I need color(73,100,143)
First filed means first column ID.

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

Once again thanks