We are trying to create a column in a chart that will assign a number to each order in a chart.
There may be multiple lines on each order. Goal would be to start with 1 for first order. This Order may have 1,2,.....20 lines.
When the next order is shown in report, column will display 2. This will continue for all orders in the chart.
The orders are sorted by Order, then Order Line No.
I have tried to accomplish this a number of ways but come up empty. Thanks in advance for any suggestions.
