problem repeating PageHeader using a matrix

Hello there,

I've got a simple report. In the header of the report I have some Informations and I want them to repeat.

In the ReportBody I have a matrix with a lot of colums - so the expand horizontically.
The rows of the matrix fit on one page, they dont cause a page break.

The Problem is, the report doesnt repeat the headers.

I tried to solve this :
putting the matrix in a rectangle
putting the rectangle in a table
using the table header for repetition

The problem now is, the free space between the outer side of the matrix an the right side of the rectangle (report is in landscape format) causes every second page an empty page.

What should I do?

Thanks for every idea. Tobi
I tried something else:

put the matrix in a subreport and the subreport in the table in main report.

same problem: header appears only on first page...
|||No ideas? Where are the specialists?
|||

I have no idea where the specialists are <s>. I am definitely not a matrix specialist.

But you might want to take a look at this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1740217&SiteID=1 for an idea.

In it, we have proposed the idea that you can set up a group on columnset number that does a page break, therefore the requisite headers and left-side columns should repeat as needed.

I have included all the code for deriving the columnset number (in both sql 2000 and 2005 versions <sigh>) in example SQL posted on that thread.

I hope it helps,

>L<