Need Help Formatting a Group Name

[BigQuincy]

I am grouping my report on a number field(airport_ref). If I put the field into the body of the report, I can format it to supress thousand separator. But when I put it into the header, I can't display it the way I want. Ex:

In the detail section I can get it to look like this:
Airport Ref: 78456789

On the header it looks like this:
Airport Ref: 78,456,789

TIA
-Q

 

[Ngolem]

create a formula {@airport_ref}
**************** start of formula ****************

space(8 - length(totext({table.airport_ref},0,"","&quot) +
totext({table.airport_ref},0,"","&quot

**************** end of formula ****************

I am assuming the largest Airport ref # is 8 characters without decimals or commas...if not adjust accordingly

You add blank spaces infront of shorter ones so that they will sort properly.

You can group on this formula and keep your report the same or also display this formula as well

hope this helps

Jim

 

[dgillz]

Another alternative is to delete the group name object and replace it with the actual database field object. Then you can format it normally. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[BigQuincy]

Thank you, that works great.