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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Headers Not Repeating on New Page

Author  Topic 

blatham
Starting Member

10 Posts

Posted - 2008-06-25 : 05:12:02
Hi

I have a table that I have set the headers to repeat on each page. This is fine if the detail rows spill on to another page but if is just the footer that is forced onto new page then the headers are absent.

I should mention that I actually have a 2nd table in the footer of the 1st table although I am pretty sure this is not the cause of the problem.

Any ideas?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-25 : 05:14:28
give option repeat footer on each page for first table.
Go to Top of Page

blatham
Starting Member

10 Posts

Posted - 2008-06-25 : 05:56:41
I don't want to repeat the footer on each page. I only want to show it once at the end, but I want to make sure that if it is on a new new page, the headers accompany it.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-25 : 05:59:38
quote:
Originally posted by blatham

I don't want to repeat the footer on each page. I only want to show it once at the end, but I want to make sure that if it is on a new new page, the headers accompany it.


but you told you've a table on footer and you want to see it on each page. how do you think you cn view the table on different pages if footer is not repeated?
Go to Top of Page

blatham
Starting Member

10 Posts

Posted - 2008-06-25 : 06:03:17
I only want to see the the second table (in the footer of the 1st table) once at the end of the 1st table, not repeated on each page.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-25 : 06:08:16
quote:
Originally posted by blatham

I only want to see the the second table (in the footer of the 1st table) once at the end of the 1st table, not repeated on each page.


Ok. so what all properties have you set for second table?
Go to Top of Page

blatham
Starting Member

10 Posts

Posted - 2008-06-25 : 06:12:55
I just have fit table on 1 page if possible.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-25 : 06:23:45
quote:
Originally posted by blatham

I just have fit table on 1 page if possible.


Have you set repeat header for second table?
Go to Top of Page

blatham
Starting Member

10 Posts

Posted - 2008-06-25 : 06:38:38
The 2nd table doesn't have headers
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-25 : 06:42:18
quote:
Originally posted by blatham

The 2nd table doesn't have headers


then were telling about first tables headers? it will repeat only if you have some data coming in next page.
Go to Top of Page

blatham
Starting Member

10 Posts

Posted - 2008-06-25 : 06:48:21
Does the footer not count as data then? I would have thought that asking for headers to be repeated for a table ought to relate to the whole table not just the data rows.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-25 : 07:02:02
quote:
Originally posted by blatham

Does the footer not count as data then? I would have thought that asking for headers to be repeated for a table ought to relate to the whole table not just the data rows.


Nope. ideally the footer itself wont repeat when you've no data. but in you case i guess its because of table data used in footer thats its moving to other page. so in which case its not actually data which is causing extra page so header wont repeat. i think if you want header in next page as well put the same header to second table and give repeat on page option.
Go to Top of Page

blatham
Starting Member

10 Posts

Posted - 2008-06-25 : 07:05:52
Yes I could have 2 tables but I don't want to show the same headers twice on the same page. It is only when the 2nd table appears at the top of a new page that I would like its headers to be visible.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-25 : 07:26:13
quote:
Originally posted by blatham

Yes I could have 2 tables but I don't want to show the same headers twice on the same page. It is only when the 2nd table appears at the top of a new page that I would like its headers to be visible.


Try giving an expression for setting hidden property of second table header.
Go to Top of Page

blatham
Starting Member

10 Posts

Posted - 2008-06-25 : 08:55:41
Hi

I could but it would be impossible to establish whether we were on a new page or not.

I have a solution to this now. The trick is to create an outer grouping on tab1 on an arbitrary value (eg 1) this means that the group only shows at the start and end of the report. No need to show the header of this new group and in the footer place my 2nd table. RS treats the grouping in which the table is placed as a data row and hence will repeat the headers if it falls on a new page.
Go to Top of Page
   

- Advertisement -