Go to the table row’s BackgroundColor property and choose “Expression…” Use this expression: = IIf(RowNumber(Nothing) Mod 2 = 0, “Silver”, “Transparent”) This trick can be applied to many areas of the report. And in .NET 3.5+ You could use: = If(RowNumber(Nothing) Mod 2 = 0, “Silver”, “Transparent”) Not looking for rep–I just researched this question … Read more
I am on a phone right now so can’t double check exact syntax 😕 Ran in to this recently. You are probably used to deploying .rdls right out of your source folder. With the new version vs 2015 running against an older server version you will need to follow a few simple steps. Make sure … Read more
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
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
I had the same question and more, and though this thread is old, it is still a good one, so in summary for SSRS 2008R2 I found… Situations You want to use a value from a URL to look up data You want to display a parameter from a URL in a report You want … 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