SSRS (SQL Server Reporting Services) is an enterprise level reporting solution available as a package in SQL Server 2005, 2008 and 2008 R2. Using this SSRS, it is very easy to create, schedule, publish and manage a multitude of reports using a variety of the data sources. In this article, let’s discuss about creating, editing and exporting a SSRS report manually.
First, let’s discuss adding an SSRS Report to a Project in BIDS.
Follow the following steps to create a report manually in Business Intelligence Development Studio (BIDS):
1. Open BIDS, select File, Open and then select Project/Solution.
2. Now, locate and open the previously created Report Server Project.
3. Then, in the Solution Explorer, it is required to right click the Reports folder and select Add> New Item.
4. Now from the Add New Item window, select “Report” and name the report (e.g., “MyReport.rdl”).
5. Then, click OK.
Yes, you’ve an empty SSRS report open in BIDS now.