Hello.

Problem: one shipment with 4 full cartons and 1 odd quantity.
I have a report that pulls the data in the detail section, but brings in 2 records: 1 for the full cartons and 1 for the odd carton.
I need to be able to print first record 4 times and show 1 of 5, 2 of 5 3 of 5 4 of 5 and print the second record once and show 5 of 5.

I tried using the page number as a counter but I get 1 of 2, and 2 of 2 - makes sense since I have just 2 records.

I heard about whileprintingrecords and local variable and tried this formula:

Package x of Y (which is the name of my formula field I would use in my "x of y")

local numbervar i;
whileprintingrecords;
for i :=1 to {@TotalPackages} do i
i:=i+1;


where {@TotalPackages}=#full +1 odd - if exists otherwise =#full

I get an error though - says last row (where I increment) is not part of the formula...

Please help! I cannot figure it out.

Thank you.

There isn't a max number of packages.