Repeat an item within a List for each page

Question

Repeat an item within a List for each page

Tim Mitchell

SSCoach

Points: 15681
More actions
July 13, 2009 at 7:41 am

#223584

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

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

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: 15681 More actions · Answer 2

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: 184394 More actions · Answer 3

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 Old Hand Points: 303 More actions · Answer 4

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