I have been trying to figure out how to repeat a table header in every page for days now (please don't tell me Set RepeatOnNewPage = true because it does not work).
Since I can
't display header of a sub report I am trying to repeat it using table header. How can I do this?
do you want to display a sub report header on new page or what.. if you have a tablix in your page then you can set it by doing below:
In the grouping pane just below your report area there is a Triangle in Column Group; Click on it >> Click on Advanced mode >> in the Row Group >> Click on First Static >> press F4 >> you will see the properties >> Set RepeatOnNewPage to True.
It'll definitely work, if you want something else please let us know.
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
yes, table mean tablix only. :) if you will right click on your table, you will get tablix properties.
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
The table on which you are working on.. Right click on topmost left hand side corner of that table where you will find properties pertaining to that table.
Once you see the properties, in the general tab you will see a section called as Header/Footer. Check the first check box saying,Repeat Report header rows on each page.
Note : One important thing is, if you are adding column headers, make sure that you are adding on the Table Header part not the detail part (To know if its table header or not, when you click on any cell of your table, you will find couple of icons on the
left most side of the table, right click on them, you will see Table Header, Table Detail and Table Footer.)
All your headings must be in the Table Header section.
Let me know if you still need any help..
Regards
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.
ranigoal
Member
205 Points
454 Posts
SSRS 2005 Repeating table header (URGENT)
Mar 27, 2012 08:50 PM|LINK
Hi all
I have been trying to figure out how to repeat a table header in every page for days now (please don't tell me Set RepeatOnNewPage = true because it does not work). Since I can 't display header of a sub report I am trying to repeat it using table header. How can I do this?
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 28, 2012 04:01 AM|LINK
do you want to display a sub report header on new page or what.. if you have a tablix in your page then you can set it by doing below:
In the grouping pane just below your report area there is a Triangle in Column Group; Click on it >> Click on Advanced mode >> in the Row Group >> Click on First Static >> press F4 >> you will see the properties >> Set RepeatOnNewPage to True.
It'll definitely work, if you want something else please let us know.
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Srikanth Kas...
Contributor
4289 Points
883 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 28, 2012 06:13 AM|LINK
On the grouping pane, Near Column Groups, click on the end button --> Advanced
Press F4 for properties of that menu, in the Properties, Say Repeat on New Page = True ALONG WITH KEEP WITH GROUP AS AFTER
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.
ranigoal
Member
205 Points
454 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 29, 2012 12:59 PM|LINK
"On the grouping pane, Near Column Groups, click on the end button --> Advanced" think this is in SSRS 2008 not 2005. I don't see this option
ranigoal
Member
205 Points
454 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 29, 2012 01:01 PM|LINK
I just want my sub header report to repeat in a new page. How can I do this without tablix? I don't have tablix control ( I am using 2005)
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 29, 2012 05:02 PM|LINK
what you are using in such case, a matrix ??
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
ranigoal
Member
205 Points
454 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 29, 2012 06:53 PM|LINK
No , Table
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 30, 2012 04:11 AM|LINK
yes, table mean tablix only. :) if you will right click on your table, you will get tablix properties.
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
ranigoal
Member
205 Points
454 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 30, 2012 12:39 PM|LINK
In the case I don't have an advanced tab. once I right click I already have repeat header group in a new page. This still does not work
Srikanth Kas...
Contributor
4289 Points
883 Posts
Re: SSRS 2005 Repeating table header (URGENT)
Mar 30, 2012 12:59 PM|LINK
Okay.. here we go then..
The table on which you are working on.. Right click on topmost left hand side corner of that table where you will find properties pertaining to that table.
Once you see the properties, in the general tab you will see a section called as Header/Footer. Check the first check box saying,Repeat Report header rows on each page.
Note : One important thing is, if you are adding column headers, make sure that you are adding on the Table Header part not the detail part (To know if its table header or not, when you click on any cell of your table, you will find couple of icons on the left most side of the table, right click on them, you will see Table Header, Table Detail and Table Footer.)
All your headings must be in the Table Header section.
Let me know if you still need any help..
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.