I have been working on an Invoice report that I have working up to a point. This last little bit is keeping me from releasing it.
I am using MS SQL Report Builder 3 to create the report. The data is laid out using a Table with 2 Groups (Customer and Invoice).
I have reviewed multiple forums and found what to turn on to keep the group together (header and footer) and how to repeat information on a new page but nowhere have I found the issue that I am running into.
I have 4 rows in the header and 6 rows in the footer for the group labeled as InvoiceNum. Each header row contains address and invoice information and the footer rows contain calculated totals from the detail data. I have each row in the header set to KeepTogether, KeepWithGrouup After, and RepeatOnNewPage and each row in the footer to KeepTogether and KeepWithGroup Before.
The report prints correctly unless the group footer is split between pages. If this happens then the only information that prints on the last page is the Page Header and the remaining rows from the footer. The problem is that the group header is not printing and the report prints on preprinted paper so the header must print on every page.
Any ideas as to what I can do to make the group header print on the last page when there is no detail printing on the page?
Thanks in advance!
I am using MS SQL Report Builder 3 to create the report. The data is laid out using a Table with 2 Groups (Customer and Invoice).
I have reviewed multiple forums and found what to turn on to keep the group together (header and footer) and how to repeat information on a new page but nowhere have I found the issue that I am running into.
I have 4 rows in the header and 6 rows in the footer for the group labeled as InvoiceNum. Each header row contains address and invoice information and the footer rows contain calculated totals from the detail data. I have each row in the header set to KeepTogether, KeepWithGrouup After, and RepeatOnNewPage and each row in the footer to KeepTogether and KeepWithGroup Before.
The report prints correctly unless the group footer is split between pages. If this happens then the only information that prints on the last page is the Page Header and the remaining rows from the footer. The problem is that the group header is not printing and the report prints on preprinted paper so the header must print on every page.
Any ideas as to what I can do to make the group header print on the last page when there is no detail printing on the page?
Thanks in advance!