Row selection

Hi,

Just curious, can the crystal report show (during report view and in the printed report) different background colour for alternate rows?

For example:
1 row background colour =silver
2 row background colour = yellow
3 row background colour = silver
and so on

thanksHi,
In the details background color write the formula
if recordnumber mod 2=1 then silver
else yellow
Madhivanan|||Thank You... :)

Anyway, is there any sites that I can refer to for this kind of code for crystal report?

Rounding in crystal

I need to display a large # ie - 123,456,789 rounded to the thousands to get 123,457

the rounding to thousands in crystal will only show this - 123,457,000

i need to take off the zero's in the end. any thoughts?

my source is a SQL table that i have formatted to show in thousands the way i want it. but when i pull it through crystal, it doesnt come back the way i want it.Divide by 1000?|||yea...i think that would be my last resort. but if i do that, i'd have to make a new formula field for each # to divide by 1000, then use that right?

its extra work that should be solved with a much quicker solution! haha|||"my source is a SQL table that i have formatted to show in thousands the way i want it" ?

Maybe create a view on the table that divides by 1000 and use that in Crystal instead of the table directly.