Repeat an item within a List for each page

  • 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

  • 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.

  • 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

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

  • 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 4 (of 4 total)

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