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
There is a complete & simpler way to do this using PowerShell. This code will export ALL report content in the exact same structure as the Report server. Take a look at the Github wiki for other options & commands #—————————————————— #Prerequisites #Install-Module -Name ReportingServicesTools #—————————————————— #Lets get security on all folders in a single … Read more
I actually ran into a similar problem where a change I needed to make resulted in an “Undocumented Error/Invalid RDL Structure” error in 2016, so I edited the RDL file so I could open it in an earlier version and make my changes. Not too hard, but you need to make a couple of tag … Read more
Ultimate solution (works in SSRS 2012 too!) Append the following script to “C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js” (on the SSRS Server): function pageLoad() { var element = document.getElementById(“ctl31_ctl10”); if (element) { element.style.overflow = “visible”; } } Actually I don’t know if the div’s name is always ctl31_ctl10: in my case it is (instead over SQL … Read more
Ultimate solution (works in SSRS 2012 too!) Append the following script to the following file (on the SSRS Server) C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js function pageLoad() { var element = document.getElementById(“ctl31_ctl10”); if (element) { element.style.overflow = “visible”; } } Note: As azzlak noted, the div’s name isn’t always ctl31_ctl10. For SQL 2012 tryctl32_ctl09 and for … Read more
In BIDS or SSDT-BI, do the following: Click on Report > Report Properties > Layout tab (Page Setup tab in SSDT-BI) Make a note of the values for Page width, Left margin, Right margin Close and go back to the design surface In the Properties window, select Body Click the + symbol to expand the … Read more