Formatting the Group Tree?

[Zaboo]

Does anyone know how to format the Group Tree.

I am running CR 8.5.

The group tree formats the numbers with commas and with 2 decimal places. I do not want that formatting, how can I change it?

Within the report, the numbers are ok and have been formatted accordingly, it is just the group tree that is the problem.

Any help would be great!
Zaboo

 

[Guest_imported]

I have the same problem.

 

[Nuffsaid]

Hi All

It seems that the only way to change the format of the group tree is to change the regional settings for numbers in control panel. I've tried it and it works, just not sure what all the "side effects" are????

Nuffsaid

 

[chelseatech]

Here is a better way, but it only works in CR8.0/8.5

Under Create Group (or Change Group if the group already exists)
Select Customize Group Name
An Alpha field is the usual response to this option
But you want to use a formula of (Click the X-2 button)
ToText({table.groupfield},0,"","&quot

http://www.chelseatech.co.nz

Editor of Crystal Clear

 

[Zaboo]

Thanks, Chelseatech, that worked.

Zaboo