Avatar of pensiongenius
pensiongeniusFlag for United States of America asked on

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
Microsoft DevelopmentMicrosoft SQL ServerSSRS

Avatar of undefined
Last Comment
Lou951

8/22/2022 - Mon
ValentinoV

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)
ASKER
pensiongenius

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
ASKER
pensiongenius

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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ValentinoV

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.
ASKER
pensiongenius

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
ASKER CERTIFIED SOLUTION
ValentinoV

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
pensiongenius

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
pensiongenius

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
ValentinoV

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.
ASKER
pensiongenius

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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
pensiongenius

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
Lou951

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.