Description:* Step by step to make Reports using Stored procedures and parameters in Reporting Services.
* Going to explain how to use Reporting Services using parameters through Stored procedure.
SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface. Reporting services features a web services interface to support the development of custom reporting applications.
In SSRS, reports are defined in Report Definition Language (RDL), an XML markup language. Reports can be designed using recent versions of Microsoft Visual Studio[1] with the included Business Intelligence Projects plug-in installed or with the included Report Builder, a simplified tool that does not offer all the functionality of Visual Studio. Reports defined by RDL can be generated in a variety of formats[2] including Excel, PDF, CSV, XML, TIFF (and other image formats[3]), and HTML Web Archive. SQL Server 2008 SSRS can also prepare reports in Microsoft Word (DOC) format.
For more information, you can visit microsoft web link here.Description:* Step by step to make Reports using Stored procedures and parameters in Reporting Services.
* Going to explain how to use Reporting Services using parameters through Stored procedure.
>>To create a new Reporting Services. Follow this.
a. Start>>Programs >> MS SQL Server 2008(5) >> SQL server Business Intelligence.
*Create a new project of Report Server Project, in our case "TestR".

* Add new Report to the project

* I took a sample db and a sample stored procedure which uses more than one parameter. Below given is the sample stored procedure.
* This is how you have to assign the stored procedure to the report
* Select your own report format and design.
*Design
*Report
*Usage of stored procedure and defining the parameters.
*In the preview of the report you will find the parameter controls to be entered or
to be selected.

* After entering the data into the controls and checking the report you will get the report.

So simple to create a report and have a professional look on the reports.