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.
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
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
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