Comma in the year, Directory tree

[starbase59]

I have grouped on the field, Year (e.g. 2008)

In Preview, on the report itself, I can format the field to get rid of the comma and decimal places, but they still show up in the directory tree(e.g. 2,008.00)

ANyone know how to get the right format in the directory tree.

 

[dgillz]

Create a formula field:

totext({Year},0,"")

And group on this formula rather than your existing database field.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?