AnsweredAssumed Answered

Adding a automatic page break and info on sum.if...

Question asked by Pierre-HuguesDemersMartel on May 5, 2018
Latest reply on May 7, 2018 by beverly

Hi,

I am modifying my layout for some reports and I am having some issues...

To make it simple, Imagine that I have some inventory with multiple levels of sections with different amount of records and of courses values...

 

Location would be the 1st digit, type of equipment would be the second, ...

ATM, I am using 3 numerical column to create the 3 digit section = x,x,x

ex:

1,1,1 = 120

1,1,1 = 100

1,1,1 = 300

1,1,2 = 15

1,1,2 = 20

1,1,3 = 200

 

With this example, I would require to display the all record for 1,1,1, the total of 1,1,1 (520) and inset a page break automatically, then the same for 1,1,2 and 1,1,3...

 

I know that I can do it with statistique and total, but then I have to make a search foe each section and sub sections...

 

I hope that you guys have an idea...

 

Thank you for your assistance

Outcomes