grouping invoices

[wilkob]

I have a query that shows as outcome all invoices and its details per date (date is chosen by user)

My idea was to make an Invoice report that shows all these details.

I have one major prolem (even if using the wizard) that I cannot get a good result.
I want:

Report to be grouped by Invoice number
sorting by items number

for the time being I still have 1 report showing
invoice 15
item 1
item 2
item 3
invoice 16
item 1
invoice 17
item 1

what I want is one report for invoice 15
followed by 1 report for invoice 16
followed by 1 report for invoice 17

what you would expect when batch printing invoices

PLEASE HELP !!!

 

[Rickster57]

report

If you have grouped your report (with Header and Footer) by Invoice Number and then sorted by item number and force a new page after each invoice that doesn't give you what you want?