Open Forum

Expand all | Collapse all

Heading on a SSRS Report

  • 1.  Heading on a SSRS Report

    TOP CONTRIBUTOR
    Posted 6 days ago

    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 6 days ago
    @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 5 days ago
    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 5 days ago
    @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 5 days ago
      |   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 5 days ago
    @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 5 days ago
    @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 5 days ago
    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 4 days ago
    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 3 days ago
    @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 3 days ago
    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 3 days ago
    @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
    ------------------------------