Repeat an item within a List for each page

  • Tim Mitchell

    SSCoach

    Points: 15652

    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: 184360

    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 Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck 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 helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

  • Tim Mitchell

    SSCoach

    Points: 15652

    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: 184360

    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 Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck 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 helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

  • 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