July 13, 2009 at 7:41 am
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
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
July 13, 2009 at 11:16 am
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
July 13, 2009 at 11:46 am
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
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
July 13, 2009 at 12:07 pm
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
January 6, 2016 at 11:12 pm
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