ssrs-2008

Reports are blank in Safari and Chrome

by

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

Listing all Data Sources and their Dependencies (reports, items, etc) in SQL Server 2008 R2

by

The following (which was modified from what beargle posted earlier) does what I was looking for. This will list all the data sources by their actual name, and all their dependent items: SELECT C2.Name AS Data_Source_Name, C.Name AS Dependent_Item_Name, C.Path AS Dependent_Item_Path FROM ReportServer.dbo.DataSource AS DS INNER JOIN ReportServer.dbo.Catalog AS C ON DS.ItemID = C.ItemID … Read more

Copy and paste a table (tablix) in SSRS

by

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

How to get named excel sheets while exporting from SSRS

by

Necromancing, just in case all the links go dark: Add a group to your report Also, be advised to set the sort order of the group expression here, so the tabs will be alphabetically sorted (or however you want it sorted). ‘Zeilengruppe’ means ‘Target group’ ‘Gruppeneigenschaften’ means ‘Group properties’ Set the page break in the … Read more

Value expression error: “[BC30456] ‘RdlObjectModel’ is not a member of ‘Reporting Services’

by

Found this bug report which exactly explains the problem I had: http://connect.microsoft.com/SQLServer/feedback/details/757358/pasting-objects-with-expressions-pastes-fully-qualified-functions Summary of the above: When you copy/paste reporting services expressions from one place to another (I copied an entire tablix, with expressions in it) all the pieces of that expression get expanded to their full names. There is a bug specific to when … Read more

Download all SSRS reports

by

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

tech