Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    11

    Unanswered: How to reset the counter?

    I have Group based on Request ID and inside that group on Type
    I need a serial no. for the Group on Type like the following
    Eg
    GH1 001
    GH2 Copy
    serial No 1
    2
    3
    GH2 Original
    serial No 1
    2
    3
    GH1 002
    GH2 Copy
    serial No 3
    4
    5
    GH2 Original
    serial No 3
    4
    5
    how do I write a formula for this kind of counter?

  2. #2
    Join Date
    Dec 2004
    Posts
    6
    Hi,

    Create a formula field with the following code in it and place it in the detail section

    WhilePrintingRecords;
    NumberVar recordnum;
    recordnum := recordnum + 1;

    Create another formula field with the follwing code, for resetting the counter and place in the group header.

    WhilePrintingRecords;
    NumberVar recordnum := 0;

    Hope this works.

    Thanks,
    Aby

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •