Hi
I need to make an invoice report with a maximum number of
sales invoice lines on each page - for instance 15 lines.
Each invoice has different no. of invoice lines - and I want to return the number of
sales invoices or the invoice numbers to fit on page 1.
For instance:
1. Invoice 5 lines
2. Invoice 3 lines
3. Invoice 6 lines
4. Invoice 4 lines
Here 4. invoice would have to go to page 2 as invoice lines would exceed 15 lines.
How can I do that ?
Br.
Mdp12
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi !
What a fun problem you have :P
I'm having so much fun figuring out how to solve your problem.
The solution would require a couple of steps & multiple excel & jet queries. So instead of trying to explain it here, I figure much simpler just to give you an example of how I would do it. The key is in the "Preparation" sheet, everything else is just reporting of what's in the preparation sheet.
Hopefully it helps
Andy -
Jet Reports Historic Posts Hi Andy
Yes it was a bit of a tricky problem :)
Very nice solution you posted - I will work on that.
Many thanks for your effort - and a Happy New Year to you.
Br.
Mdp12
Please sign in to leave a comment.