Repeating report item in page header

Hi,
In a SSRS 2005 I am having a problem:
My report consists of one table report en multiple subreports.
The report and subreports have to be paged by product. So page 1 contains
the data of product 1 for the report + each subreport.
I've achieved this by putting the report and subreports within a list item,
which is grouped by product.
To put the product of the current page in the header I put product on the
dataset of the report and put it in a textbox on the report. Next I put the
product in the header by refrencing the textbox with
=reportitems!product.value.
My problem with this solution is that when 1 product generates more then one
page, I only see the product in the header of the first page. The header of
the next page is empty. I would like to see the product repeated on every
page until the page shows the next product.
Does anyone have a solution or work-around for this?Hi Pieter,
not sure whether the following will help (or that you've tried this
already). If you select the table, right click and select 'properties' and in
the tab 'general' you'll see at the bottom the following option: 'repeat
header rows on each page'... you can even select that the header needs to
remain visible when scrolling. You'll have to tick both options if you want
the header to remain visible while scrolling on all pages.
hope it helps & best regards,
mischa
"Pieter M" wrote:
> Hi,
> In a SSRS 2005 I am having a problem:
> My report consists of one table report en multiple subreports.
> The report and subreports have to be paged by product. So page 1 contains
> the data of product 1 for the report + each subreport.
> I've achieved this by putting the report and subreports within a list item,
> which is grouped by product.
> To put the product of the current page in the header I put product on the
> dataset of the report and put it in a textbox on the report. Next I put the
> product in the header by refrencing the textbox with
> =reportitems!product.value.
> My problem with this solution is that when 1 product generates more then one
> page, I only see the product in the header of the first page. The header of
> the next page is empty. I would like to see the product repeated on every
> page until the page shows the next product.
> Does anyone have a solution or work-around for this?