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.