Report to show incremental count (1 Viewer)

jimbojames30

New member
Local time
Today, 14:44
Joined
Nov 12, 2018
Messages
2
Hi All,

Apologies if this has been coved but i could not find using a google search,

i have a report to show orders that are due in to be processed, one record per order but an order may consist of 4 boxes, what i want to be able to do is to have 1 of 4, 2 of 4 , 3 of 4 etc if i print the report so i can stick it to each of the boxes

I thought of using page numbers but that wont work as its one page per report, I have a field saying 4 boxes so not sure how to achieve this.

Has anyone come across this issue before and hopefully advise me on this
 

Ranman256

Well-known member
Local time
Today, 10:44
Joined
Apr 9, 2015
Messages
4,339
in the query, add a column: 1
this is the counter,
in the report, add this field, set to RUNNING SUM = TRUE
put a label after the box: "of 4"

then when the report prints, it will read:
1 of 4
2 of 4
etc
 

jimbojames30

New member
Local time
Today, 14:44
Joined
Nov 12, 2018
Messages
2
hi there,

Thakns for your reply, sorry but im not the best and find it a little difficult to follow

I have a column call Packages (4 for example)

i added this column to the report but when i went to the properties and selected running sum TRUE wasnt an option, 'over group' or 'Over All' was the only ones i could select

do you have an example that i could possible take a look at?
 

Users who are viewing this thread

Top Bottom