How to create first SSRS report

In our previous post we created our first SSRS project. Now we are going to add our first SSRS report in our project.

Follow below step to add a new report in our project.
In solution explorer right click on Report and select Add, select New Item.
In Add new item window select report under report project.
In name box type name MyFirstReport and click on OK to create your first SSRS Report.

As you noticed a new file is added in your Report folder with extension rdl. rdl means report definition language. All SSRS reports are stored in a rdl file.

In our next post we are going to explain main component of SSRS development
studio.

How to create first SSRS project

Before starting to show how ti create your first SSRS project we assume that you have following software installed in your machine.

1. Any supporting database for this tutorial we are using SQL Server.
2. Microsoft Business Intelligence development suit.

Step 1 Open SQL Server Business Intelligence Development Studio.

1. Click on Start, select All Programs, Microsoft SQL Server 2008 R 2,SQL Server Business Intelligence Development Studio.
2. NOTE: If you opening SQL Server Businesses Intelligence Studio first time click on Business Intelligence Settings.

Alternative: open run and type devenv.exe and press enter. Assuming you have only one installation of SQL Server Business Intelligence Development Studio.

Step -2 Create your first project.

1. In the File menu select new, select project (Key board short cut Ctrl+Shift+N)

2. From the Installed Templates list, Select Business Intelligence.

3. Click on Report Server Project.

4. Type Name MyFirstReport.

5. Click OK to create your first project.

In next post we are going to add a report in our project.

Visit this link for blog post with images.

Download code files.

SSRS Error No starting report is specified

Error: The project cannot be debuged because no.starting report is specified. In the project menu, select Properties and enter a value for Start Item.

Cause: When you created new report in ne ssrs project and forgot to define starting report, on click of execution debugger through above issue.

Solution: Solution is available in error message. Just right click on your project and select properties. In general properties under debug section provide your report name for start item.