Open Forum

Expand all | Collapse all

Heading on a SSRS Report

  • 1.  Heading on a SSRS Report

    TOP CONTRIBUTOR
    Posted Feb 11, 2019 02:42 PM

    Hello
    Running GP2018
    We have invoices printing via an SSRS report.  We want the heading to repeat on each page.  I have changed the properties of the Tablix, and the static members, but I cannot get the header to repeat on each page.

    Any suggestions?

    Thank you

     



    ------------------------------
    Mary Mallazzo
    Fromkin Brothers
    Edison NJ
    ------------------------------


  • 2.  RE: Heading on a SSRS Report

    GPUG ALL STAR
    Posted Feb 11, 2019 04:30 PM
    @Mary Mallazzo,

    ​It can be tricky, for sure. But this may not be your best bet for getting an answer to your question.

    I did a Google search for "ssrs sql server 2016 invoice design" and got quite a few hits. Here's one:

    https://www.intertech.com/Blog/use-sql-server-reporting-services-to-generate-an-invoice-document/

    Sorry I can't help more directly.

    Sincerely,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List
    ------------------------------



  • 3.  RE: Heading on a SSRS Report

    SILVER CONTRIBUTOR
    Posted Feb 12, 2019 08:50 AM
    Steve's link is awesome! I wish I had found that 2.5 years ago when I was last attempting to fix our ssrs invoices! But it doesn't really address how to make ssrs repeat headers on subsequent pages. I have used the fill in blank lines and alternate row backgrounds to great effect, so I will be keeping that handy ;)

    https://stackoverflow.com/questions/11285923/tablix-repeat-header-rows-on-each-page-not-working-report-builder-3-0

    This has good screen shots, people asking questions and getting more detail, but if you still can't find it, I will be happy to walk you through it!


    ------------------------------
    Rebeccah Grimes
    Application Specialist, MS Dynamics GP
    Tech24
    A Commercial Foodservice Repair, Inc Company
    ------------------------------



  • 4.  RE: Heading on a SSRS Report

    GPUG ALL STAR
    Posted Feb 12, 2019 09:33 AM
    @Rebeccah Grimes,

    Nice StackOverflow link. I looked at that one, too, in trying to figure out a way to help @Mary Mallazzo. But I saw in her (brief) message that she had tried changing properties in the tablix, so I figured that I'd skip that one. But maybe she hasn't tried the Advanced Mode properties, so bravo! for bringing it to light!

    I don't suppose that you'd consider making a GPUG blog post about repeating SSRS headers, would you?​​

    I'm glad that you found the link I posted useful. And, Mary, I hope that the combination of the two can help you.

    Sincerely,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List
    ------------------------------



  • 5.  RE: Heading on a SSRS Report

    TOP CONTRIBUTOR
    Posted Feb 12, 2019 11:16 AM
      |   view attached
    I have used the advanced option and coded both static members under "Row Groups" to "repeat on new page"...  see attached.
    Still no header on 2nd page.
    When I change static members under Column Groups to "repeat on new page"  I receive error that the property must be set to false...see attached.

    Puzzling...

    ------------------------------
    Mary Mallazzo
    Fromkin Brothers
    Edison NJ
    ------------------------------

    Attachment(s)

    xlsx
    SSRS_Header_Issue.xlsx   91K 1 version


  • 6.  RE: Heading on a SSRS Report

    SILVER CONTRIBUTOR
    Posted Feb 12, 2019 11:49 AM
    @Mary Mallazzo ​ you are so close! I promise. Static under column group should all be set to false. It is the Static under ROW groups that you want to set the RepeatOnNewPage to True.

    Settings for header repeat
    I chose the last static line to have RepeatOnNewPage set to True on, the static lines above are set the same way. All Static under Column Groups are set to False. Try switching KeepTogether to False for everything you want to repeat. My ([InvoiceNumberProject]) line is the first line I have KeepTogether set to True, the KeepWithGroup = After you have correct.

    While I don't remember the exact trick, I do remember being stuck in this stage of matching my settings to what everyone says works, and I feel like it was something as simple and nonobvious as KeepTogether being false on the rows you want repeated.

    @Steve Erbach I will have to see what I can pull together for a blog post!​

    ------------------------------
    Rebeccah Grimes
    Application Specialist, MS Dynamics GP
    Tech24
    A Commercial Foodservice Repair, Inc Company
    ------------------------------



  • 7.  RE: Heading on a SSRS Report

    GPUG ALL STAR
    Posted Feb 12, 2019 12:42 PM
    @Rebeccah Grimes,

    When your blog is ready, I will make sure that everyone here knows about it! It's no small thing to create a blog entry.​ Thank you for considering it!

    Sincerely,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List
    ------------------------------



  • 8.  RE: Heading on a SSRS Report

    SILVER CONTRIBUTOR
    Posted Feb 12, 2019 11:50 AM
    This link from Microsoft may help, SSRS: How to Repeat Headers on Each Page

    ------------------------------
    Rich LaMarche
    Senior IT Specialist
    Norwich Public Utilities
    Norwich CT
    ------------------------------



  • 9.  RE: Heading on a SSRS Report

    TOP CONTRIBUTOR
    Posted Feb 13, 2019 09:56 AM
    SSRS Add Page Header
    There are actually two separate items you can have the document repeat.  There is a page header and there is a report header.  You have to know which one you want to repeat.  You can add a page header by right-clicking in the body of the report and going to Insert -> Page Header (or footer).  Every page that prints will get that header.


    SSRS Report Header

    There is also a report header, which is what others have touched on: a header specific to the report (usually the row headers) which repeats on every page of a multi-page report.  This can be accessed by clicking on the upper left corner of your report area (Tablix) and going to Properties.  Set the box on "Repeat header rows on each page".

    There is an option to repeat the Column headers, but I haven't found any use for it.  There are two other boxes marked "Keep header visible while scrolling" which may be useful if the report user gets the report through SSRS - though this behavior is sometimes flaky.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------



  • 10.  RE: Heading on a SSRS Report

    GPUG ALL STAR
    Posted Feb 14, 2019 10:26 AM
    @Blair Christensen,

    Hard to imagine why someone would want a Report Header ​to repeat on each page. Like, a Report Header is, essentially, a cover page for the report, yes? Title, Author, Purpose, description of contents, etc., right?

    Sincerely,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List
    ------------------------------



  • 11.  RE: Heading on a SSRS Report

    TOP CONTRIBUTOR
    Posted Feb 14, 2019 11:00 AM
    Or as we use it: Company, Report name, date, filters, even column headers on a few reports.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------



  • 12.  RE: Heading on a SSRS Report

    GPUG ALL STAR
    Posted Feb 14, 2019 11:26 AM
    @Blair Christensen,

    You remind me that Report Writer usually duplicates report headers as page headers... so its definition of "report header" gets blurred.

    Regards,​

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role