Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Grouping/nested layout in designer

Avatar

Level 1

New to the workbench, and my first task in trialing the software is to produce an invoice.

These invoices may span 40+ pages. They involve two levels of totals.

I have put together a sample XML file with all the data I need, based on the existing paper invoice.

I can get a table populated no problems at all.

What I cannot do is create a grouping based on the first column in the table.

The columns in the table are pipeline name,delivery point , volume , amount

I want to break on pipeline to show a total of volume and amount for a single pipeline with 1-n delivery points.

n is not a fixed number , could be 1 could be 50.

At the footer of the table I want grand totals for all pipeline/delivery points.

I have tried nesting tables and putting a conditional break in based on pipeline. No luck.

Naturally none of samples appear to address this issue.

Can someone send me an XML  file and a form template showing me how this might work.

2 Replies

Avatar

Level 4

Are you looking for something like this?  Where Delivery Points for each pipeline continue and at the end of the PL1 pipeline, there is a total for that section?

Pipeline   NameDelivery PointVolumeAmount
PL1A10,000 $       1.50
B15,000 $       0.75
$       2.25
PL2AB5,000 $    10.25
PL2L1,000 $       1.50

Avatar

Level 1

Yes thats close to what I want, with a grand total  below the table or in table footer.