Eliminate Thousand Separator & Decimal Places 1

[CrystalVis]

I have a number data type field called account_id. The report is group based on account_id. The data is displayed ok in CR desinger and ActiveX viewer. example: 1234567. However, when I export to Excel, the the data look like this: 1,123,567.00. I have right click the group name, select format field, customize, uncheck Thousands Separator and set decimals to 1. I have also create a formula: ToText(account_id) then group on the formula. This method display the data as 1,123,456.00 in CR Designer as well as when I export it to Excel. Does anyone have a suggestion on how I can solve this problem. I'm using CR ver8.5 and database is Oracle. Your help/suggestion is greatly appreciated.
TIA

 

[synapsevampire]

Try:

totext({accountid,0,"&quot

But don't group on this formula, just use it for display/export.

-k

 

[CrystalVis]

That did it...Thank you very much for your quick respond and your help.