SAP Knowledge Base Article - Public

1542062 - How to create Hierarchical Numbering for groups in Crystal Reports?

Symptom

  • How to create Hierarchical Numbering for groups in Crystal Reports?
  • For e.g.:  
    •

Country1              1

     City1               1.1

         Region1       1.1.1

     City2               1.2

         Region1       1.2.1

         Region2       1.2.2

Country 2              2

And so on...

Environment

 

  • Crystal Reports XI R2 (All Patch levels)
  • Crystal Reports 2008 (All Patch levels)

    • Resolution

    1. Create a Crystal Report against the Xtreme Sample Database
    2. Create 3 Groups in the following order (Insert -> Group):

      3. Customer.Country, Customer.City, Customer.Region

    3. Create a formula called ‘TopGroup’(Field Explorer ->Right click ‘Formula fields’ ->New) as follows:

      4. WhilePrintingRecords;

      numbervar x:= x+1;

    4. Place this formula beside Group #1
    5. Create a formula called ‘Level2’ as follows:

      6. WhilePrintingRecords;

      numberVar x;

      numberVar y;

      totext(x,0)+"."+totext(y,0);

    6. Place this formula beside Group #2
    7. Create a formula called ‘Level3’ as follows:

      8. WhilePrintingRecords;

      numberVar x;

      numberVar y;

      numbervar z;

      totext(x,0)+"."+totext(y,0)+"."+totext(z,0);

    8. Place this beside Group #3
    9. Create a formula called ‘IncLevel2’ as follows:

      10. WhilePrintingRecords;

      numbervar y := y+1;

    10. Place this formula beside the formula called ‘Level2’
    11. Create a formula called ‘IncLevel3’ as follows:

      12. WhilePrintingRecords;

      numbervar z:=z+1;

    12. Place this formula beside the formula called ‘Level3’
    13. Create a formula called ‘ResetLevel2’ as follows:

      14. WhilePrintingRecords;

      numberVar y:= 0;

    14. Place this formula on the Group Footer #1
    15. Create a formula called ‘ResetLevel3’ as follows:

      16. WhilePrintingRecords;

      numbervar z:=0;

    16. Place this formula beside the formula called ‘IncLevel2’
    17. Refresh the report and you’ll see that all the Groups and Sub-groups have correct hierarchical numbering

    Keywords

    Hierarchical Numbering, Crystal Reports , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

    Product

    Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2

    Attachments

    Hierarchical Numbering.rpt