Hey people.
I dont know the best way to show, maybe ill upload a pdf, but ill try to explain my situation:
1."Line at bottom"
I have a report, with "Grouped by InvoiceID".
The report generates maybe about 20 invoices each time it is run.
The line items of the invoice are in a table with ONLY outside borders, therefore the the InvoiceID footer has a single line on it, so that when the last detail item is written the line shows up and ends the table.
I cant put a bottom border on the detail section, because we dont want every record to have a bored line below it.
NOW, the issue is that when you go to 2 pages, there is no line at the bottom of the page on page 1, as the InvoiceID grouping hasnt ended, and is going to another page.
Ideas? ty for any help you can give.
2. "Total at bottom"
I have the totals for the invoice in the Page Footer.
I originally had in the InvoiceID Footer, however the business owner wants the invoice total to appear down the bottom right of page, not below the end of the table, therefore the companys always have to look in the same place for the invoice total.
Therefore I moved from invoice Footer to Page footer.
This is all great, however once again, when the invoice goes to TWO pages, the Invoice Total appears on BOTH pages... instead of just page 1 of invoice ID.
So really, i either need "Page footer only appears on last of the invoice ID pages each time" or "Invoice ID footer appears just above page footer"
I have no idea how to achieve these features and have so far said "I can't do that" to my boss... but I'm willing to learn if there are any ideas out there