How can I get data fields to repeat on each page, since they cannot be placed in the Header?

For example, we need the document number at the top of each page. Also, when using a table, is there a way to make the table Header print on each page when the table goes to multiple pages
Thank you.

Answer this question

How can I get data fields to repeat on each page, since they cannot be placed in the Header?

TRodS
I don't think that would help. These are just column headers that are static. I just want them to show up on each page.
fantus
It is above the list. The textboxes for the column headers show up on the first page but none after that.
inthefields
Hi, Carlolyn,

You can insert a row above the table/list header, drop the field to this row, and set the RepeatOnNewPage property to true for this row.

insert--drop--set

Good Luck.

Long
sakile
Yes I picked list1, the list I put the databound textboxes in.
Ramin
Even though you can't refer to fields in the page header or footer, you can refer to other textboxes. The expression to use is of the form =ReportItems!Textbox8.Value. This will only work if you have a Textbox8 that repeats on every page in the report. The textbox can be hidden. See this discussion for more details: http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/972db4dbd28a234b/481f4ea1a6b89bbc#481f4ea1a6b89bbc
alext_2002
You need to put the textbox ABOVE the list, not IN the list.

Good Luck,

Long
Digitalboy
Try this:
Click the row you want to repeat on each page, on the properties window, set RepeatOnNewPage to true.

Good Luck.

Long
nobsay
I'm using the method of referencing a hidden text box to show a document number in the header of every page of my report.

Works very well when viewed in the viewer and when printed. But exporting to PDF (or even printing to an external PDF printer such as the free PDFCreator) causes the document number to not appear! I even set the background color of the textbox so I know it is printing the box, just not the information in it.

Help!
DevLady

Using RepeatOnNewPage does work for a table, thank you.

I still have a situation where I need to repeat a data field on everypage. I'm using a list and when the list goes to a new page, I need a field (not in the list) to be repeated (ie. document number). Thanks for any help.
FatherJack
I can't get this to work with a list. The RepeatOnNewPage property for tables works,

but Repeat report item with data region on every page doesn't do anything.

Any help
Mr. Turner
Long,
I do not see a Header on a list. It works fine when I have a table, but I need it work work with out using a table.
Thanks,
ebence
Sorry Carolyn,

My fault, for list, you can put a textbox above the list ( say list1 ), drag the field you want to repeat on every page to the textbox, right click the textbox, select properties,select general, check "Repeat report item with data region on every page", select "list1" from the dropdown list, then click OK.

Hope it works this time.

Good Luck.

Long
ConfusedJohn
Would using a parameter work instead Did for me.

http://forums.microsoft.com/MSDN/showpost.aspx postid=339319&siteid=1

Greg
ashade
Interesting. After you checked "Repeat report item with data region on every page", did you select any control from the dropdown list

You know what, that works for me, it should work for you.

Good Luck,

Long
How can I get data fields to repeat on each page, since they cannot be placed in the Header?

Answer this question