I have a multi-column report question. We've set up the report as a subreport and have three columns per page we want to display and a total we need to display at the bottm. The page also needs to have a header.
When the report goes past one page, the page header didn't show initially, but we have almost fixed that. On any page after the first page, the column headers do not show as they do on the first page. Finally, we need to total the values from all pages and display that value on the page.
We have gotten the page header to show for each page correctly after some work, but we can not get the column headers to show automatically. We rigged it with group header and then suppress as needed, based on the page number. The problem is, is that the header for the third column will sometimes show when there is no data to display below it.
Finally, when the total needs to be displayed, it does so correctly for the first two pages most of the time, but not always. We have found that if there is a full first page of three coluns and a second page of two full columns with the third one empty, we will get the column header for that third column and the total will appear on a blank page following the second page. By blank page, I mean no page header, which is not what we need.
Any help would be much appreciated.