Skip to Content
author's profile photo Former Member
Former Member

Adding line numbers to groups in a report

Hi,

I've got a report which is split into two groups, One group for the order number then a group for the product code within the order.

The reason for that is there's often more then 1 product code on the order and then beneath the product code theres maybe 10 lines, for example we may have an order for product code one for 500 cases but we despatch 9 x 50 cases so the total is 450.

So we group them and then do sums within the group.

Is it possible that on the product code group if shows 1 for one product code but if theres two product codes in that group it shows the first product code as 1, then the second 2, third 3 etc... then when order number changes revert back to 1?

http://www.beersgang.co.uk/Test.rpt

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 31, 2011 at 02:12 PM

    Pallet,

    Does this help you?

    Either:

    Create a Running Total.

    Steps:

    1) Choose Running Total from the field explorer. Select the unique field in your table.

    2) Put Count or distinct count

    3)Evaluate for each record, or group

    4)Reset is Never

    or

    Put the following in a formula field and use it:

    WhilePrintingRecords;

    Global NumberVar x;

    x:=x+1;

    x

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2014 at 08:05 AM

    Follow Under Stap , to apply group in Sr.No

    Steps:

    1) Choose Running Total from the field explorer. Select the unique field in your table. ( ex -> your table P.K )

    2) Type of summery ---> count or distinct count

    3)Evaluate ->>> for each record, or group

    4)On Change of Group ->> your group name select

    Now done .

    Message was edited by: Vaibhav P Patel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.