March 10, 2011 at 4:23 am
Hi All
Im having real trouble with a report in SSRS BIDS 2008
I have a table within a report and the data is based on a group. It contains one row for the headers and one row for the data.
when I run the report the row headers are not repeating on each page as I scroll.At first I tried changing the tablix properties to repeatcolumnheader and repeatrowheader. I tried first repeat column header, then repeatrowheader then tried setting them both to true to no avail.
I then tried the properties of the row, repeat header rows on each page. again to no avail.
So then I have tried advanced mode to show the static, and changed keeptogether =true, keepwithgroup=AFter and repearonnewpage =true. to No avail
Which static am I suppose to be changing, there is three static before the group. I tried the first one as this highlight the first cell of the row with the headers to no avail. I tried the one before the group but I get the following error "The tablix 'table1' has an invalid TablixMember. A TablixMember that is dynamic (i.e., has a Group specified) or has dynamic descendants must have the KeepWithGroup property set to "None".
Build complete "
So i tried setting all 3 statics to true, AFTER , true to no avail. Ive been working on it for hours! and searched loads on the internet.
Also I have noticed this is only a problem if I have a group on the table. I have reports with no groups and the advanced mode options works fine
Thanks
R
March 10, 2011 at 11:54 am
Not that you won't get help here, but you may be better off posting this in an SSRS Forum: http://www.sqlservercentral.com/Forums/Group416.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply