09-04-2003, 12:00 AM
|
webadmin@datadynamics.com
Joined on 12-12-2005
Posts 0
|
Help needed with "wide" reports - multi-page spreads
|
|
|
|
|
Originally Posted By: Tom Murphy<temurphy@demisoft.com>
I am writing an AR in code. I have a column that needs to remain fixed on the left, and a spread of columns that is too wide for one page, so it must wrap onto one or more pages, like vertical bands. I am able to get it working generally, but the page break issue is a problem. Here is what is happening: In the FetchData method, I detect which column is needed to start with (column 1 on page 1, column 15 on page 2, etc), and then feed data to the report fields based on the proper columns for the current page. I also feed data to header fields to supply the correct column headers.
In my PageEnd event, I am advancing the column reference for the next page. When the columns for one horizontal stripe have been used up, I advance the beginningRow to the correct position on the vertical dimension and reset the beginningColumn to 1.
All this works fine, except for one thing: The FetchData event is hit BEFORE the PageEnd event. This means that on page 2, which should start with the same row as page 1, but with the next set of columns, I am getting a "leftover" row from this pre-fetch event at the end of page 1. It prints a row from the first column set that should not appear until page 3, causing all of the rows on page 2 to be shifted down relative to page 1.
I have tried using LayoutAction to control this but have not found a solution.
Can anyone give me a sample of a working wide report like this? I'm desperate. Thanks
Tom
|
|
|
|
|
Report
|
|
|
|