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
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
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
You should move the constraints on prescriptions.filldate into the ON condition of the join, and remove it from the where clause: LEFT OUTER JOIN prescriptions ON prescriber.dea_no = prescriptions.dea_no AND prescriptions.filldate >= ’09-01-12′ AND prescriptions.filldate <= ’09-17-12′ Otherwise, entries for which there are no prescriptions end up with nulls in prescriptions.filldate, and the WHERE clause … Read more
Although John Sansom’s solution works, there’s another way to do this, without having to use a potentially inefficient scalar valued UDF. In the SSRS report, on the parameters tab of the query definition, set the parameter value to =join(Parameters!<your param name>.Value,”,”) In your query, you can then reference the value like so: where yourColumn in … Read more