Last post Apr 11, 2012 03:37 PM by donatelj
Mar 27, 2012 04:50 PM|ranigoal|LINK
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?
Mar 28, 2012 12:01 AM|Ashutosh Pathak|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.
Mar 28, 2012 02:13 AM|Srikanth Kasturi|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
Mar 29, 2012 08:59 AM|ranigoal|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
Mar 29, 2012 09:01 AM|ranigoal|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)
Mar 29, 2012 01:02 PM|Ashutosh Pathak|LINK
what you are using in such case, a matrix ??
Mar 29, 2012 02:53 PM|ranigoal|LINK
No , Table
Mar 30, 2012 12:11 AM|Ashutosh Pathak|LINK
yes, table mean tablix only. :) if you will right click on your table, you will get tablix properties.
Mar 30, 2012 08:39 AM|ranigoal|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
Mar 30, 2012 08:59 AM|Srikanth Kasturi|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..
Mar 30, 2012 10:11 AM|ranigoal|LINK
Thanks Srikanth for your help. I am still having a problem and not sure what am I missing. Ok I took out the group just see it it works. Now I have Only table header and details. I
put the text I want to repeat on the header and the long label in the details and still won't repeat.
Mar 31, 2012 05:54 AM|Ashutosh Pathak|LINK
as i said in my prevoius post, please have a look into again.
Apr 05, 2012 08:58 AM|ranigoal|LINK
I don't have Advanced mode option in 2005. I even google it and it is only for ssrs 2008
Apr 11, 2012 03:37 PM|donatelj|LINK