Matrix report not in proper columns on following pages

[papalphaus]

I have a matrix report in which the horizontal columns continue on the next page. After the last horizontal column, it continues with the next vertical row without a break. Hope the example helps. The vertical bar indicates new page. Page 1 has some header information above the matrix so it starts half way down the page. Page 2 starts at top of page. Page 3 is at top of page. Using * to repsent space or data to force items to line up to help the readability.


Page 1 * * * * * * * * * * * *page 2 * * * * * *page 3
* * * *Heading1 heading2| * * * *heading 3 | heading3
Item 1 data1 * *data2 * |item 1 * data3 * * *|
. * * *data1* * data2 * | * * * * data3 * * *|
. * * *data1* * data2 * | * * * * data3 * * *|
. * * *data1* * data2 * | * * * * data3 * * *|
Item x data1 * *data2 * |item x * data3 * * *|
* * * * * * * * * * * * |item x+1 data1 data2|itemx+1 data3


How do I get item x+1 to start on a new page with the proper heading above it?

This is Reports 6i on 8.1.7 database.

 

[nagornyi]

Put the matrix into frame with fixed horizontal and variable vertical elasticity.

 

[papalphaus]

I tried that, it didn't work. Here is my current layout:

test_count inside repeating
frame that is (variable
vertical, expand
horizontal) that includes
result value and its frame

item_name inside repeating result value inside
frame variable vertical repeating frame that is
expand horizontal fixed vertical
expand horizontal


All the above inside a frame that is VARIABLE VERTICAL, EXPAND HORIZONTAL


I tried making the outermost frame fixed horizontal and variable vertical which did not do the desired results. I then returned that frame to VARIABLE VERTICAL, EXPAND HORIZONTAL and added a new frame around it that was fixed horizontal and variable vertical. Still did not get desired results. Any new suggestions will be appreciated.

 

[nagornyi]

What's the "inside repeating frame?". Looks like it is not the strandard matrix layout.Did you create the matrix manually or using report wizard? If manually, we may be talking about different things. I was able to reproduce the error using the report wizard matrix and it was fixed by making the fram arond the matrix variable vertically and fixed horizontally.

 

[papalphaus]

Thanks for your previous suggestion. It at least got me headed in the right direction. I finally had to put a page protect on the outermost frame that held the matrix and this accomplished most of what I wanted. Now, the column headings do not start until the last column. That is the heading for the first column is above the 3rd column. The headings for the 2nd & 3rd columns are over nothing. I have tried the 'Keep with anchoring object' for the matrix and nothing appears to have happened. Any suggestions for this issue.

 

[nagornyi]

Still, is it a regullar matrix report with frames crossed, or "frame insede frame?" What are the groups/fields in your data model and frames/fields in the layout model?

 

[papalphaus]

Yes it is a regular matrix. In a regular matrix, the cell is inside intersecting frames from the down field and the across field. That is what I was trying to describe. I took the frame enclosed the matrix and extended it the full width of the page, then made the horizontal fixed, then set the page protect on this frame. With the page protect turned off, I have what I originally had. With the page protect on, the column headings shift to the right and start on the last data column.

 

[nagornyi]

Did you create the matrix manually or using the Wizard? If manually, there is a poosibility you missed something in the matrix structure needed for correct layout

 

[papalphaus]

Thanks for all your suggestions. There must have been something screwed up in the report. I was maintaining it, written by someone else. I had deleted the layout and used the default wizard several times with no luck. I finally deleted both the layout and the query, then re-created the query and layout and then everything worked.
Thanks again for all your suggestions.

 

[nagornyi]

Thanks for letting us know and I am glad the issue is resolved. Another example that often it's easier to recreate then to maintain. So. looks like the old query returned those empty headers?