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
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
    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
      Posts: 55
      Veteran Member
        thank you - that did it