Rounding in crystal

[scroller52]

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.

[dforosisky]

Divide by 1000?

[scroller52]

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

[JaganEllis]

"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.