Repeat an item within a List for each page

  • Tim Mitchell

    SSCoach

    Points: 15653

    Good morning all,

    I've created an SSRS report, but I'm stuck on a formatting issue. I have a List control on the page that often runs onto more than one page for a single record. I have a Textbox that I'm using as sort of a header within that List. I'd like to have this Textbox repeat on each new page. It does currently repeat for each new record, but not for a single record spanning multiple pages.

    Thanks in advance,

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • Jack Corbett

    SSC Guru

    Points: 184380

    Hey Tim,

    I'm attaching a simple list report using AdventureWorks that I think does what you want and it seems pretty simple, but I may be missing something in your question. I have no groups on the list, but I set the HideDuplicates property of the static Manager Name textbox to the Dataset and the same thing for the textbox that lists manager names and they repeat on the next page.

    Let me know if that is what you are really looking for.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • Tim Mitchell

    SSCoach

    Points: 15653

    Hey Jack,

    I finally figured this thing out. I found that what I needed to do was to use the Group Header function, but this is only available on the Table control and not the List control. I hadn't been using the Table control because the output of the data needed to be free-form rather than in a grid.

    So I got creative and added a Table control, then dropped in a Rectangle control into the details area of the Table. The Rectangle allows you to free-form design your data using Textboxes or other controls. I was then able to use the Group Header for the Table control and repeat the header on each subsequent page, even when a single output row spills over into multiple pages.

    Thanks for the help!

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • Jack Corbett

    SSC Guru

    Points: 184380

    Awesome. I was wondering why you weren't using a table, but figured there had to be some reason.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • SWATH

    SSC Veteran

    Points: 273

    Hi..I have the same requirement pls can u eloberate ur solution.I have list with 3 grids ,the text box should repeat on every page..

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply