Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
werseyjersey
Starting Member
47 Posts |
 Posted - 2008-11-03 : 22:35:02
|
| I have a page header that gives the following information:FTE Staffing Report by Pay Period --- "The current cost center"I want to display whatever the "Cost Center" is for the particular page. For example:I have 130 which is equal to Cost Center - Chicagoand I have 240 which is equal to Cost Center - Philadelphia. There is a page break after each cost center and I want each page to display the "130 - Chicago Center" on the page header. How would I go about having this header update the cost center each time it changes for the page? I want the page header and cost center to be on each and every page.werseyjersey |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2008-11-05 : 12:30:02
|
| I don't think you can display this in the header. You could try inserting a group in your table and grouping by your cost center instead. There are settings in the group to control page breaks and such.AjHey, it compiles. |
 |
|
|
|
|
|
Page Header