Click here to Skip to main content
14,032,830 members
Click here to Skip to main content
Add your own
alternative version


60 bookmarked
Posted 24 Sep 2008
Licenced CPOL

Using Report Builder to build reports

, 24 Sep 2008
Rate this:
Please Sign up or sign in to vote.
How to build reports from Report Builder and save it on the Report Server.


Report Builder is a strong tool provided in SQL Server 2005 Reporting Services. You can just go ahead and make reports of your own choice, with your desired columns and calculations. Once built, you can go ahead and save it on a Report Server to access anytime in the future, too. How can we setup a Report Builder environment on a 'Server' such that we can access the Report Builder on our local machines. This article will show how you can setup the environment for Report Builder and then build reports using the tool provided.


Some time back, I was involved in getting reports built from the Report Builder provided in SQL Server 2005 Reporting Services, along with making reports and deploying them on a Report Server. I had a hard time finding how exactly to make reports from the Report Builder. It was new, and there was hardly any information on the Internet either. In fact, I have not found any article on how to build reports using the Report Builder even today. So, I thought of writing one, to save some time for the first time users of the Report Builder.

Using the code

The first thing required is to create a Data Source, a Data Source View, and a Report Model.


Create a New Project, and select Report Model Project:


Create a new Data Source, a new Data Source View, and a new Report Model. For creating a new Data Source, provide the connection details and select the database on which the reports need to work on. Select this newly created Data Source while creating the new Data Source View, and then select the created Data Source View for creating the Report Model.




We can select Tables and Views out here that will be displayed in the Report Builder as available options to drag-drop fields to view in the report.





Click Finish to create the Report Model. After this, build it and deploy it.


Once this is successfully done, the whole setup to work with the Report Builder is done. Now, log into http://localhost/Reports (the 'localhost' here will be the server machine name, such that we can access the Report Builder from our machines.)


We can check if the newly deployed Report Model can be found in the Models folder above and if the Data Source is defined in the Data Sources folder. Now, click on the Report Builder. When we click the Report Builder, it will be downloaded on the local system to work with:



The user selects the Data Source and clicks OK. The UI appears like:


Now, we can drag-drop the fields on the right side. All the relations are maintained, and they can be traversed in the left side tree above. Below, in the left side, are the fields available to be dragged-dropped.


Once done, we can run the report using "Run report" at the top, in the toolbar.


How simple, isn't it? Now, what if we need to filter out some results based on certain conditions? The Report Builder has that facility too. We can put a filter on it using the "filter" at the top, in the toolbar.


Once we set a filter and re-run the report, we have:


What about saving the built report now? We can just click the Save button at the top, and a prompt appears with the Report Server folder structure.


We can go ahead and save the report in our personal folder specified on the Report Server. And now, it can be accessed any number of times in the future.


You can edit and save it the way you prefer. Filters, sorting, design, everything is in the user's hands. A report can also be viewed through the Report Server.

Points of interest

As I told you earlier, it was a good experience learning how to implement the Report Builder feature for my project. This gave me a lot of flexibility and options for quite a few reports that were needed. Adding to it, the user's choice and preferences are maintained using it too.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Sandeep Mewara
Software Developer (Senior)
India India
Current location: Bangalore, India.

You may also be interested in...


Comments and Discussions

Questioncan i use sql query to generate a report Pin
rajni412-Aug-12 21:30
memberrajni412-Aug-12 21:30 
GeneralMy vote of 1 Pin
David.jos12323-Jun-12 5:36
memberDavid.jos12323-Jun-12 5:36 
Need improvement
QuestionI have a error in deployeeing time in ssrs? Pin
raju12305-Apr-12 20:30
memberraju12305-Apr-12 20:30 
QuestionHow to create dashboard in ssrs? Pin
raju12305-Apr-12 20:22
memberraju12305-Apr-12 20:22 
GeneralMy vote of 1 Pin
Not Active21-Mar-10 12:23
mentorNot Active21-Mar-10 12:23 
GeneralUsing Report Builder with another application Pin
AcidAndroid9-Feb-09 4:54
memberAcidAndroid9-Feb-09 4:54 
AnswerRe: Using Report Builder with another application Pin
Sandeep Mewara25-Feb-09 23:05
mentorSandeep Mewara25-Feb-09 23:05 
GeneralRe: Using Report Builder with another application Pin
wielanb26-Jun-09 16:17
memberwielanb26-Jun-09 16:17 
AnswerRe: Using Report Builder with another application Pin
Sandeep Mewara24-Jan-10 19:04
mentorSandeep Mewara24-Jan-10 19:04 
GeneralRe: Using Report Builder with another application Pin
PaulMcKenzie27-Jul-09 12:29
memberPaulMcKenzie27-Jul-09 12:29 
GeneralGood Work Pin
suresrkumar13-Nov-08 23:28
membersuresrkumar13-Nov-08 23:28 
GeneralRe: Good Work Pin
JonnyLA17-Nov-08 19:18
memberJonnyLA17-Nov-08 19:18 
AnswerRe: Good Work Pin
Sandeep Mewara26-Nov-08 18:34
mentorSandeep Mewara26-Nov-08 18:34 
QuestionHow coding is involved here Pin
Kaithy Sommane25-Oct-08 6:05
memberKaithy Sommane25-Oct-08 6:05 
AnswerRe: How coding is involved here Pin
Sandeep Mewara10-Nov-08 6:30
mentorSandeep Mewara10-Nov-08 6:30 
AnswerRe: How coding is involved here Pin
JasonC7211-Nov-08 18:41
memberJasonC7211-Nov-08 18:41 
General"Advanced" Pin
Selvin25-Sep-08 2:56
memberSelvin25-Sep-08 2:56 
AnswerRe: "Advanced" Pin
Sandeep Mewara25-Sep-08 3:07
mentorSandeep Mewara25-Sep-08 3:07 
GeneralRe: "Advanced" Pin
Manish Ranjan Kumar25-Sep-08 20:33
professionalManish Ranjan Kumar25-Sep-08 20:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web01 | 2.8.190423.1 | Last Updated 25 Sep 2008
Article Copyright 2008 by Sandeep Mewara
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid