SSRS Tutorial: Part 1 - Create A Simple Report

Introduction

This article explains the following,

• How to create an SSRS project.
• How to add shared data sources to your Project.
• How to add a shared dataset to your Project.
• How to add a report to your Project.
• How to populate the data by using a shared dataset.

Here are the steps to create a simple report in SSRS,

Step 1. If you're using a Microsoft SQL server, then go to Start and click on Search and select SQL Server Data Tools.

If you're using SQL server 2008r2 or earlier versions, go to Start, Microsoft SQL Server, and select SQL server Business Intelligence studio.

Step 2. Click on File Menu, and expand New, then select Project,

After that, expand Business Intelligence and select Reporting Services and Report Server Project Wizard. Give a meaningful name to your Solution and Project. Specify an appropriate location for where you want to save this Project by clicking on Browse.

Step 3. Create Shared DataSource

Go to Solution Explorer and right-click on Shared Data Sources, expand Add, then click on New Item.

Then you will see the following wizard. Provide the data source name in this article. I gave it as DB_Jaipal. And then, click on Edit to make the connectionString.

After clicking on Edit, we have to provide the following Connection Properties,

• Select the Server name.
• Select the "Use SQL Server Authentication" radio button.
• Enter the User name and Password in the password text box.
• Check the "Save my password" checkbox.
• Select the "Select or enter a database name:" radio button.
• Select the database to which you want to set the connection.
• Click on the "Test Connection" button to ensure the connection can be established.