Friday, March 9, 2012

Paging Header and Detail

I would like to create a report with header and detail, like an invoice with invoice # and line items. I'd like the invoice # to come from a summary query that breaks 1 invoice # per page. Then I'd like to display the line items below the invoice # on each page, from a second query passing the invoice number as a parameter. How is this done? Do I need a subreport?

ie:

header from summary query:

invoice 101

detail from detail query passed invoice # = 101:

line 1 item A

line 2 item B

line 3 item C

page

header from summary query:

invoice 102

detail from detail query passed invoice # = 102:

line 1 item A

line 2 item B

line 3 item C

page

...

Thanks.

If you want to use two queries, yes, you need a subreport to display the line items.

If you can return all the data in one query, then you just need a table with group (by invoice #). The invoice information would be in the group header, and the line items would be in the detail rows.

No comments:

Post a Comment