You need to set the PageName of the Tablix Member (group), NOT the PageName of the Tablix itselfs. If you got the right object, if will say “Tablix Member” (Tablix-Element in German) in the title box of the properties grid. If it’s the wrong object, it will say only “table/tablix” (without member). Also, be advised … Read more
You are likely getting the error message Report Builder was unable to paste successfully because somewhere in the grid there is a cell that uses Custom Code From the Report i.e. you cannot copy a textbox with this custom code: “Code.MyCustomeCode()” – Report Builder was unable to paste successfully This has been a reported bug … Read more
To repeat rows with column headings for a table with row groups In Design view, select the table. The Grouping pane displays the row groups. On right side of the Grouping pane, click the down arrow, and then click Advanced. The Grouping pane displays static and dynamic tablix members for each group. You can only … Read more
There is a way to move columns through the designer: insert the number of blank columns you want to move in your destination spot shift-left-click on the cells (NOT the header column) you want to move right-click and select the Cut command right-click on top of the destination columns and select Paste delete the now … Read more
It depends on the tablix structure you are using. In a table, for example, you do not have column groups, so Reporting Services does not recognize which textboxes are the column headers and setting RepeatColumnHeaders property to True doesn’t work. Instead, you need to: Open Advanced Mode in the Groupings pane. (Click the arrow to … Read more