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

Hello,

   I have one master SSRS report file that contains twelve individual subreports in the body of the report. I had a Page Header section for each of the individual subreports but when I ran the master report it didn't work because none of the page headings on each of the individual subreports did not display. So is it possible to display page headings for each of the individual subreports that are within a master report file using Microsoft Reporting Services 2008? If so how is it done? I'm a beginner at SSRS so if you can give me an detailed steps that would be greatly appreciated.

   If you have any questions just let me know.

Thanks for your help,
Ting
pensiongeniusAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ValentinoVBI ConsultantCommented:
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)
0
pensiongeniusAuthor Commented:
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
0
pensiongeniusAuthor Commented:
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
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

ValentinoVBI ConsultantCommented:
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.
0
pensiongeniusAuthor Commented:
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
0
ValentinoVBI ConsultantCommented:
As you've noticed, clicking the grey static items doesn't reflect really well in terms of selected items on the tablix design itself.  And it can be quite confusing...  Don't worry about that too much.

All you need to do is click the first grey static item in the Row Groups, then set the RepeatOnNewPage property to True.  That's all.  It should work, even with subreports.  (I tested this before replying.)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pensiongeniusAuthor Commented:
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
0
pensiongeniusAuthor Commented:
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
0
ValentinoVBI ConsultantCommented:
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.
0
pensiongeniusAuthor Commented:
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
0
pensiongeniusAuthor Commented:
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
0
Lou951Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.