Thanks for the suggestions provided here. We have found a solution and it did turn out to be related to the parameters. SQL Server was producing a convoluted execution plan when executed from the SSRS report due to ‘parameter sniffing’. The workaround was to declare variables inside of the stored procedure and assign the incoming … 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
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
If anyone is interested: Ctrl+Alt+D combo helped me.
It’s because of lack of privilege for the user you are running the report builder, just give that user or a group a privilege to run report builder. Please visit this article Or for shortcut: Start Internet Explorer using “Run as Administrator” Open http://localhost/reports Go to properties tab (SSRS 2008) Security->New Role Assignment Add DOMAIN/USERNAME … Read more
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
The problem here is that if there are too many data bars the labels will not show. To fix this, under the “Chart Axis” properties set the Interval value to “=1”. Then all the labels will be shown.
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
=Format(Now(), “MM/dd/yyyy hh:mm tt”) Output: 04/12/2013 05:09 PM Full list of format options might be found here. Kudos to @MattGibson.
It depends on the tablix structure you are using. In a table, for example, you do not have column groups, so Reporting Services does not recognize which textboxes are the column headers and setting RepeatColumnHeaders property to True doesn’t work. Instead, you need to: Open Advanced Mode in the Groupings pane. (Click the arrow to … Read more