creating ssrs reports in visual studio 2010

• Open BIDS.
• Fileà New Project à Business Intelligence Projects à Report Server Project à “<Project Name>”.
• This will open BIDS designer showing Solution explorer on right hand side with two folders with name Shared Data Sources and Reports.

 

Create Data source

• Data source is where we specify Database Server, Database names and required credentials etc form where reports will fetch data.
• Data Sources can be of two types.
• Shared: Common for all reports in a project.
• Embedded: Specific to a particular report only.
• For defining new shared data source right click on shared data Sources folder  in Solution Explorer and select “Add New Data Source Option".

 

Add Report

—Now right click on Reports folder in solution explorer and select Add New Item à Report.

—This will add a .rdl file to our solution.(Report Definition Language file.)

—Now Report Designer along with Report Data and Solution Explorer panes will be shown as in screen.

—Report Data Pane contains three folders and provides options for adding new Data Sources, Datasets, Parameters and Images.

—Built-in Fields : This folder contains build-in fields are like Execution Time, Report Name etc.

—Parameters: This folder contains all parameters defined for a report.

Images: This folder lists Images used in current report.

—Drag and Drop “Execution Time” Built-in field on report designer.

—Click on Preview tab to view your first report.