2 Replies Latest reply on Jul 26, 2009 3:16 PM by Fastcars1

    Grouping/nested layout in designer

    Fastcars1

      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.