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<

Problem rendering Matrix control

All,

I am able to display the data in matrix, however I need to place it next to a table report item, so that the rows in table and matrix together would represent the data for same entity. In order to accomplish that, the Matrix rows need to be properly aligned with Table rows. But thats not happening. For some reason, in the Layout view they align properly, but when I Preview the report, the rows are not aligned. I have checked the cell sizes of both in the properties, they are both identical. So, I am very surprised why the Matrix row size is growing less than Table row size when the report is generated. Any ideas how to fix this?

Thanks.Never mind, I figured it out. It was nothing, just one of the table cells getting its text wrapped around and making the entire row seem bigger.sql

Problem of "Export to Excel" for "Chart" within "Matrix"

Hi
Please help to fix the following problem.
I design a report using a matrix to show the Sales data. Within the matrix,
I want to use a Bar Chart to show some the data.
Preview and Export to pdf format is ok and does not have any problem.
However, I get the error message "Specified Cast is not Valid" when I try to
export to Excel. How can I fix it, please help!
Thank You
TonyI have The same problem but with a table on report.
Anybody knows what is causing it?
"Tony" wrote:
> Hi
> Please help to fix the following problem.
> I design a report using a matrix to show the Sales data. Within the matrix,
> I want to use a Bar Chart to show some the data.
> Preview and Export to pdf format is ok and does not have any problem.
> However, I get the error message "Specified Cast is not Valid" when I try to
> export to Excel. How can I fix it, please help!
> Thank You
> Tony