reporting-services – w3toppers.com

SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?

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

SSRS 2005 Set SimplePageHeaders on the report instead of the server?

Instead of overriding the existing Excel renderer, what you want to do is supply another renderer that strips out the headers and include this in the list of renderers available to the export menu. You almost have the solution – instead of modifying the current Excel renderer you want to supply another one. There are … Read more

When to use RDLC over RDL reports?

From my experience there are few things to think about both things: I. RDL reports are HOSTED reports generally. This means you need to implement SSRS Server. They are a built in extension of Visual Studio from SQL Server for the reporting language. When you install SSRS you should have an add on called ‘Business … Read more

Reporting Services export to Excel with Multiple Worksheets

To late for the original asker of the question, but with SQL Server 2008 R2 this is now possible: Set the property “Pagebreak” on the tablix or table or other element to force a new tab, and then set the property “Pagename” on both the element before the pagebreak and the element after the pagebreak. … Read more

SSRS Expression Divide by Zero Error

You can add a function to your report code that handles the divide by zero condition, this makes it a bit easier to implement in multiple cells, e.g. Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double) If IsNothing(Divisor) Or Divisor = 0 Return 0 Else Return Dividend/Divisor End If End Function You … Read more

Does the iif function compute both paths in SSRS or is it short-circuited?

You’re right, it doesn’t short circuit. That sucks. You’ll have to do something like this: = Iif(KgSold = 0, 0, Revenue) / Iif(KgSold = 0, 1, KgSold ) The switch function should also work.

SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome

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

Compare SQL Server Reporting Services to Crystal Reports [closed]

On the one-hand, Crystal Reports is a steaming pile of expensive and overhyped donkey poo, and on the other hand SSRS actually fulfils all the promises that CR marketing makes – and it’s free. My contempt for CR stems from many years of being obliged to use the horrible thing. There’s really no point in … Read more

SSRS multi-value parameter using a stored procedure

You need three things: In the SSRS dataset properties, pass the multi-value param to the stored procedure as a comma-delimited string =Join(Parameters!TerritoryMulti.Value, “,”) In Sql Server, you need a table-value function that can split a comma-delimited string back out into a mini table (eg see here). edit: Since SQL Server 2016 you can use the … Read more