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
I found the above answers quite useful but not really general purpose, they all need some other major build system like Ant or Maven. I wanted to generate a report in a simple one-shot command that I could call from anything (from a build, test or just myself) so I have created junit2html which can … 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
Looks like SSRS ReportViewer control. You have 2 options: If you’re using default SSRS ReportViewer.aspx you can pass parameter through the URL, like that: http:///ReportServer/Pages/ReportViewer.aspx?PathToReport&rs:Command=Render&ExamYear=2013 If you’re using ReportViewer control directly, pass parameter in the codebehind: ReportParameter examYearParam = new ReportParameter(“ExamYear”, 2013); reportViewer1.ServerReport.SetParameters(examYearParam);