views:

1295

answers:

1

Hi, I have few subreports in a sql main report(.rdl file) using VS/SSRS 2008. The subreports start approximately on the middle of the page in the main report detail section. I have one group in main report, shows header information and pass one parameter - ReportID to each subreport. I also have checked both: (1) Row Headers – “Repeat header rows on each page” and (2) Column Headers – “Repeat header columns on each page”, on general tab of Tablix properties of the main report. If I have few detail lines in the subreport, so that all can be rendered on page one, everything is ok., if I have more detail lines in the subreport so that it's not possible to print all on one page, the subreport renders from the fist page and moves on to page two, three and so on.

When I have more than one page of data in the subreport, it is also started on page one, and continues renders on second page and so on... However, it doesn't show the main report's column/row headers on subsequent pages of the subreports? I've noticed that when next item/ReportID starts in my main report group, it prints column header only on the first page but not any subsequent page and so on...

I also tried to check only ONE, either (1) Row Headers – “Repeat header rows on each page” OR (2) Column Headers – “Repeat header columns on each page”, on general tab of Tablix properties of the main report BUT didn’t work?

Any ideas how to print header info on each page when subreport has more than one page data?

A: 

Pagination is always fun in SSRS.

Have you looked at the page size/interactive of the subreport? This may stop the subreport paging, but I don't know if it's what you want.

An older article on pagination

And a newer one

gbn