Crystal Report - Group Tree in LBI displays Employee Number with commas

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member

Hello,

I've developed a labor distribution report in crystal.  It's grouped by cost center, then employee number beneath that.  When I view the Group Tree in Crystal, the employee number displays with no commas - something I tweaked in the report because it originally displayed with commas - since employee number is numeric.

However, when I publish the Crystal report into LBI and view it, the employee number in the group tree shows up with the commas again.  I don't know why LBI is ignoring the Crystal report group tree formatting.

Does anyone have a solution to this?

thanks

Char
Veteran Member Send Private Message
Posts: 62
Veteran Member
did you go into group, change group, then options and check use a formula? the formula should be
totext({table.field},0,'')
Jan
Veteran Member Send Private Message
Posts: 55
Veteran Member
thank you - that did it