I currently have a print section called “report” which includes a dynamic table using data from a detail table. Within the detail table there is a field called “D_Counter” which can change.
This is an example of the data, with column three being “D_Counter”:
D; Name; 1; Address; Price
D; Name; 1; Address; Price
D; Name; 1; Address; Price
D; Name; 1; Address; Price
D; Name; 2; Address; Price
D; Name; 2; Address; Price
D; Name; 2; Address; Price
I need the “report” section to start a new section (cloned section?) every time the D_Counter field changes.
So report section 1 would have the table rows that have the “D_Counter” as 1, report section 2 would have the table rows that have the “D_Counter” as 2, and so on.
Is it possible to clone a section based on a field change in a detail table?
Or could it be achieved with a forced page break in the dynamic table?
I can share my table html if that would be helpful.
There are two other sections in the template, so three sections in total. (letter, objection and report)
And yes there are other fields as well as another detail table.
I should have included more lines in my data sample, it looks more like this for one record:
B; Name; Address…
C; PropertyNumber; Name; Barcode;…
C; PropertyNumber; Name; Barcode…
D; Name; 1; Address; Price…
D; Name; 1; Address; Price…
D; Name; 1; Address; Price…
D; Name; 1; Address; Price…
D; Name; 2; Address; Price…
D; Name; 2; Address; Price…
D; Name; 2; Address; Price…
The fields from the B line are extracted, then C; line fields go into a detail table and D; line fields go into another detail table.
I’ve got the cloning feature to work on the “objection” section that uses the data from the C; lines, to create two “objection” sections.
The issue is with that “D_Counter” change within the D; lines.
If it helps, the “D_Counter” corresponds to one of the C lines. So the first C; line links to the D; line that has the counter “1” and the second C; line links to the D; line that has the counter “2”
So, ideally the sections would print:
Letter
Objection
Report
Objection
Report
But I understand that might not be possible, and it’s fine to print the sections:
Letter
Objection
Objection
Report
Report
Please find attached an attempt at what I think you want. You’ll notice that the detail table breaks on overflow but it also break on change of customer.
For this I compare the ID of the customer to the previousID.
Thanks for taking the time to look into this for me
I couldn’t open the file due to using a different version, would you be able to re-supply? The version I’m using is: Version 2024.2.1.22757 • Enterprise
