Re: Matrix Report columns not lining up

<papalphaus_at_yahoo.com> wrote in message news:1105720063.710471.277150_at_f14g2000cwb.googlegroups.com...
> 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.
>

Hi.
I've only ever done 1 matrix report but I had problems with the matrix 'breaking up'
My report was based on 1 row per person and the break up usually occured where 2 people
hand identical names.
eg, Steven Smith
I solved that by concatenating an extra column surname || forenames || person_id
The using that as a sort column instead of merely surname, forenames it made certain that each row was unique.

matrix 'break ups' usually happen where you don't have a unique sort column combination.

Hope that helps.

Arthur Received on Sat Feb 19 2005 - 01:52:15 CET