How to display page headings on individual subreports that are within a master report file using SSRS 2008

As you have discovered that is unfortunately not possible.  A subreport will render the report without header/footer.  The only page header you can use is the one of the main report...

Perhaps it's an option to put the info from the headers in the actual body of the subreports?  Possibly combined with grouping on a table?  I know this is not exactly the same but sometimes you need some creativity to get something done in SSRS :)

The following can also be interesting to read through: Display Row and Column Headers on Multiple Pages (Report Builder and SSRS)

Hi ValentinoV,

   Thanks for your reply.

   Yes that's what I thought. I was hoping that was not the case but that's SSRS. Before working with SSRS, I thought it was suppose to be a reporting tool that you can do allot of things without having to get creative. What I was hoping to do, I know you can do that with Crystal Reports writer.

   Yes after discovering that flaw, I removed the page header section in the individual subreports and created a textbox containing an expression for the Report Title to display at the beginning of the subreport. I noticed for all of the subreports that if there are multiple pages, the column labels does not print at the top of the page instead it's just the detail. Refer to the screen shot file attachment for an example of how the tablix looks like as well as the Group properties for the Row group. On the Group properties window, the fields that you see for the General option is the same fields that I have for the Sorting option. I tried the two things that was suggested in the link to read above. It didn't work because I still can't get the column labels to display at the top of multiple pages. How would I do this?

Thanks for your help,
Ting
Question-About-Displaying-Row-an.doc

Hi ValentinoV,

    I hope you are doing well. When you get a chance could you review my reponse to your most recent comment.

    If you have any questions for me just let me know.

Thanks for your help,
Ting

Hi Ting,

Sorry for my late response, I must have missed your reply somehow...

If I understand you right, you want the tablix headers to repeat across pages?  That should be possible, here are the steps to achieve that.

Select the tablix and activate the Advanced Mode for the Row/Column Groups.  That's done by using that small dropdown to the right of the Column Groups window.

Your Row Groups now show a grey (Static) item as first one in the list.  Select that.  Now look at the Properties window.  One of the properties there is called RepeatOnNewPage.  Set this to True to repeat the header columns on each page.

This is something you'll need to repeat for each subreport in which you'd expect this functionality...

Hope this is clear a bit?  If not let me know...

Valentino.

Hi ValentinoV,

    No worries. I'm sure you get tons of questions asked. Thanks for getting back to me.

    Yes you are correct. I want the tablix headers to repeat if there are multiple pages for the subreports. I set the RepeatOnNewPage property to True and it didn't work. The header columns is still not printing if the subreport is more than two pages. The file attachment is what I included previously so you can see how my report is layed out.

     Note: I noticed that when I selected the first grey (Static) item, the Investment Name box was highlighted. When I clicked on the second (Static) item in the list for the Column Groups, the Name for Communications was highlighted. Why is that? Isn't that part of the row group?

      Do you have any other suggestions? If I didn't explain it good enough, just let me know.

Thanks again for your help,
Ting
QuestionAboutDisplayingTablixHea.doc

Hi ValentinoV,

  Yes I did notice that.

  Okay.   I followed your steps and the tablix headers were not printing at the beginning of multiple pages. I noticed when I clicked on the first grey static item, there is a Keep With Group Property as well. So I set the Keep With Group Property to After as well as the Repeat On New Page property to True. Then the tablix headers were printing at the beginning of page 2. Refer to the word document for the screen shot.

   Note: When I set the  Keep With Group Property to Before, it didn't work.

   Why is it when I use the Keep With Group Property with the Repeat On New Page property, the tablix headers are now printing on multiple pages?

Thanks again for your help,
Ting
RepeatingTablixHeadersUsingTwoPr.doc

Hi ValentinoV,

   Just checking in if you had a chance to review my latest reply to your question that I posted on the November 4th?  I just had one more question for you before I close this question.

    Have a good day.

Thanks for your help,
Ting

Hi Ting,

Must have missed your previous comment, sorry about that (busy times)...

About your question: I have no idea to be honest.  When I tried this out, just setting the RepeatOnNewPage property was sufficient.  Apparently in your case the situation is a little different.  Good thing that you got it to work though!

Best regards,
Valentino.

Hi ValentinoV,

  No worries. Yes as I have learned from working with SSRS, you just have to try different things to get work the way you want it to in SSRS.

Thanks,
Ting

I've requested that this question be closed as follows:

Accepted answer: 500 points for ValentinoV's comment #a39612406
Assisted answer: 0 points for pensiongenius's comment #a39622187

for the following reason:

ValentinoV recommendation worked.

Thanks,
Ting

This technique doesn't seem to work with SQL 2012 SSRS.  I keep getting an error stating "The tablix 'Tablix1' has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false."  Not sure how to get around that to get the column headers to print on every page in a subreport.