Click here to Skip to main content
15,617,231 members
Articles / Database Development / SQL Server
Posted 24 Sep 2008


59 bookmarked

Using Report Builder to build reports

Rate me:
Please Sign up or sign in to vote.
4.80/5 (48 votes)
24 Sep 2008CPOL3 min read
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)

Written By
Architect Intuit India
India India

A software professional for more than 17+ years building solutions for Web and Desktop applications.

Currently working at Intuit India.

Website: Learn By Insight
Github: Sandeep Mewara
LinkedIn: Sandeep Mewara

Strongly believe in learning and sharing knowledge.

Comments and Discussions

Questioncan i use sql query to generate a report Pin
rajni412-Aug-12 21:30
rajni412-Aug-12 21:30 
GeneralMy vote of 1 Pin
David.jos12323-Jun-12 5:36
David.jos12323-Jun-12 5:36 
QuestionI have a error in deployeeing time in ssrs? Pin
raju12305-Apr-12 20:30
raju12305-Apr-12 20:30 
QuestionHow to create dashboard in ssrs? Pin
raju12305-Apr-12 20:22
raju12305-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
AcidAndroid9-Feb-09 4:54 
AnswerRe: Using Report Builder with another application Pin
Sandeep Mewara25-Feb-09 23:05
mveSandeep Mewara25-Feb-09 23:05 
GeneralRe: Using Report Builder with another application Pin
wielanb26-Jun-09 16:17
wielanb26-Jun-09 16:17 
AnswerRe: Using Report Builder with another application Pin
Sandeep Mewara24-Jan-10 19:04
mveSandeep Mewara24-Jan-10 19:04 
GeneralRe: Using Report Builder with another application Pin
PaulMcKenzie27-Jul-09 12:29
PaulMcKenzie27-Jul-09 12:29 
GeneralGood Work Pin
suresrkumar13-Nov-08 23:28
suresrkumar13-Nov-08 23:28 
GeneralRe: Good Work Pin
JonnyLA17-Nov-08 19:18
JonnyLA17-Nov-08 19:18 
AnswerRe: Good Work Pin
Sandeep Mewara26-Nov-08 18:34
mveSandeep Mewara26-Nov-08 18:34 
QuestionHow coding is involved here Pin
Kaithy Sommane25-Oct-08 6:05
Kaithy Sommane25-Oct-08 6:05 
AnswerRe: How coding is involved here Pin
Sandeep Mewara10-Nov-08 6:30
mveSandeep Mewara10-Nov-08 6:30 
AnswerRe: How coding is involved here Pin
JasonC7211-Nov-08 18:41
JasonC7211-Nov-08 18:41 
General"Advanced" Pin
Selvin25-Sep-08 2:56
Selvin25-Sep-08 2:56 
AnswerRe: "Advanced" Pin
Sandeep Mewara25-Sep-08 3:07
mveSandeep Mewara25-Sep-08 3:07 
GeneralRe: "Advanced" PinPopular
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.