In SSRS you can easily present users with database-driven single selection drop-down lists as parameters to pass to the stored procedure running your report. In the following steps I’ll go through the process of adding a single selection drop-down list to your report.
SQL Server Reporting Services (SSRS) has an in-built function called Globals!ReportServerUrl that allows you to return the URL of the SSRS report on the server. If you are looking at customizing part of your SSRS report depending on the Server that it is hosted on, then this is a useful function.
SQL Server Reporting Services (SSRS) is a handy tool for generating reports quickly. However, like most reporting packages, making the reports dynamic rather than simple static canned reports takes a bit of effort. For example, you may want to let the users of your report choose from a list of options. You could then apply these…
When first looking into writing SQL Server Reporting Services (SSRS) Reports in Visual Studio, it’s easy to think that creating a report will be possible straight out of the box with one of the existing templates that Visual Studio comes with. Somewhat surprisingly, this is not the case for Visual Studio 2012 and 2013.