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