• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 452
  • Last Modified:

Grouping Formula for Crystal Report XI

I am trying to a group a report where all similar job numbers group together using field {TimeTracking.JobNo}.  

For example:

GH1 - 12345-**
  Details 12345-01
               12345-02
               12345-03, Etc

GH2 - 12346-**
   Details  12346-01
                 12346-02
0
bmessmore
Asked:
bmessmore
1 Solution
 
mlmccCommented:
Try a formula like

Assuming it is always 5 characters
     Left({TimeTracking.JobNo},5)

If it is not always 5 characters but it is the characters before the - use

     Split({TimeTracking.JobNo},'-')[1]


mlmcc
0
 
bmessmoreAuthor Commented:
Perfect.  Thank you
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now