Simple way to creating the SSRS reports (Very Basic & Very Easy)

Very very simple steps with full of step by step screen shorts

Step 1:- Open Microsoft visual studio 2008

File à New Project àReport Server Projectà Name it as “SampleSSRSReport”

Empty solution explorer will display like

Step 2:-Right Click the shared data source àAdd New Data Source

Screen will display like

Click Edit button for configure the data base connection

Give all the required parameters

Make Shure check the check box Save mu password (Because wile accessing the report without save that password it will ask every time)

To check the connection successful click the Test connection button

If connected successfully message will show like

Step 3:- Creating the Report

Right Click the ReportsàAddàNew ItemàSelect Report TempleteàName it as Employee.rdl

Click Add empty report is created

Step 4:- Configure the data source

Go to right side click the Report Data

Configure the shared dataset to this report

Right click the Data sourceàAdd data Sourceà Follow the below screen below

Step 5:-

Now creating the DataSet for the Report binding

Data SetàAdd Data SetàFollow the screen bello for proper understanding

First of all I will show Query type with Text

Click OK

With Query Type Store procedure

Click ok

Right click the empty design

InsertàTable à

Mouse over on the table it will show like to bind the data set columns to the table

Like that configure the required fields

Configure the parameter as dropdown

Right click the parameter àParameter propertiesà Follow below screen

Create One more dataset for drop down

Click Preview button

That sol the simply creating the SSRS reports

For any clarifications or queries please don’t hesitate to call or Email

Phone :- + 91-9492179390

Email :- lannam@technobrainltd.com (or) lokeshtec@gmail.com