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 |
|
sue1127
Starting Member
23 Posts |
 Posted - 2009-03-09 : 15:37:53
|
| I would like to put column headers in the table header and have them appear on every page.Is this possible in SSRS 2005?Thanks very much.Sue |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-10 : 04:56:07
|
| yup. its possible. you've property called repeat table headers on each page for table in report. just set it and you will get header on each page of report. |
 |
|
|
sue1127
Starting Member
23 Posts |
Posted - 2009-03-10 : 08:18:21
|
| Thanks, visakh16. That worked |
|
|
|
sue1127
Starting Member
23 Posts |
Posted - 2009-03-10 : 08:32:55
|
| Oops, I spoke too soon. What I want is to repeat the table header, but I want to have a field in there(the accont number, which is what I'm grouping by), and have the new account number show on each page.What I'm trying to accomplish is to have the field that I am grouping on show on the page above the column headers. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-10 : 14:47:03
|
| how can you put field on table header? it shows only static value whereas field values will vary. seems like what you need is put it in detail row with grouping applied. |
|
|
|
sue1127
Starting Member
23 Posts |
Posted - 2009-03-10 : 15:59:44
|
| I tried to put it in a 2nd detail row, but it showed before every transaction detail. I'm not sure what you mean by "detail row with groupint applied" |
|
|
|
|
|
|
SSRS 2005 Table header repeating on every page