Tabled report

Posted by: lukepoet on 4 August 2017, 2:44 pm EST

  • Posted 4 August 2017, 2:44 pm EST

    Hello! I'm new user of Active Report... can u help me? I want to build a report like the attachment but I don't find a graphic object that can do it.
    My problem is that my customer want a tabled invoice; so if the lines of invoice stopped in the middle of page, like the attachment, my report not continued the design of the border until end of page. How can I do? Thanks a lot.
  • Replied 4 August 2017, 2:44 pm EST

       In fact, this kind of report its not that hard.

      All the data over the invoice data goes in the ReportHeader and PageHeader Sections on AR.

       The invoice line goes in the Details Section

    And the Subtotals and tax calculations goes on the PageFooter and ReportFooter

       The trick int his kind of report is that the only data that is repeated constantly are the invoice lines, thats why it had to be coded in the Details Section.

       The other data is not repeated, so it can be wherever you want.

       But, the way I see and as I understand, what you want is print the lines just the way ur pic looks like. And that can be done (as I know) through code!!!
  • Replied 4 August 2017, 2:44 pm EST

    An unbound GroupHeader with UnderlayNext set to True could do your column layout. This is the setup I would use based on how I interpret your graphic and post...

    GroupHeader1 with your invoice header data, like date, code, address, etc. and your column headers for the line items,

    GroupHeader2 with UnderlayNext set to True and the line layout for your line items, enough to fill the page.

    Detail section with fields for one line item (it will repeat once for each record in your recordset).

    GroupFooter2 should probably be blank

    GroupFooter1 with your totals and tax data.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels