Thank you Randy,
I actually found the solution.
I placed a formula in the onFormat that calculates the number of zones I get. I wrote a loop that jumps a culumn, until the zone reaches 8. So the total always appears in column 8.
Thank you very much anyway
A bientôt
Hi,
Thank you for your reply.
This is what I've got:
Zone 1 Zone 2 Zone 3... Zone 6 Total
USA Europe ROW Total
Transport 1000 1000 1000 4000
Services 0 10 0 10
Packaging 20 20 20 60
TOTAL 1020 1030 1020 4070...
My report has 8 columns. The data is grouped so that at the end of a reccord, the data appears on the following column.
Since I do not know how many records (there cannot be more than 7 anyway) there are per group, I do not know where the last record will show.
The last record shows data of...
My report has 8 columns. The data is grouped so that at the end of a reccord, the data appears on the following column.
Since I do not know how many records (there cannot be more than 7 anyway) there are per group, I do not know where the last record will show.
The last record shows data of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.