Click here to Skip to main content
Click here to Skip to main content
Go to top

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.

Introduction

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.

Background

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.

1.JPG

Create a New Project, and select Report Model Project:

2.JPG

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.

13.JPG

18.JPG

19.JPG

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.

20.JPG

21.JPG

22.JPG

23.JPG

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

24.JPG

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.)

5.JPG

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:

RRB.JPG

6.JPG

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

7.JPG

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.

9.JPG

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

10.JPG

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.

12.JPG

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

15.JPG

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.

16.JPG

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.

17.JPG

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.

License

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

Share

About the Author

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

Comments and Discussions

 
Questioncan i use sql query to generate a report Pinmemberrajni412-Aug-12 21:30 
GeneralMy vote of 1 PinmemberDavid.jos12323-Jun-12 5:36 
Need improvement
QuestionI have a error in deployeeing time in ssrs? Pinmemberraju12305-Apr-12 20:30 
QuestionHow to create dashboard in ssrs? Pinmemberraju12305-Apr-12 20:22 
GeneralMy vote of 1 PinmvpMark Nischalke21-Mar-10 12:23 
GeneralUsing Report Builder with another application PinmemberAcidAndroid9-Feb-09 4:54 
AnswerRe: Using Report Builder with another application PinmemberSandeep Mewara25-Feb-09 23:05 
GeneralRe: Using Report Builder with another application Pinmemberwielanb26-Jun-09 16:17 
AnswerRe: Using Report Builder with another application PinmemberSandeep Mewara24-Jan-10 19:04 
GeneralRe: Using Report Builder with another application PinmemberMcCodeJunky27-Jul-09 12:29 
GeneralGood Work Pinmembersuresrkumar13-Nov-08 23:28 
GeneralRe: Good Work PinmemberJonnyLA17-Nov-08 19:18 
AnswerRe: Good Work PinmemberSandeep Mewara26-Nov-08 18:34 
QuestionHow coding is involved here PinmemberKaithy Sommane25-Oct-08 6:05 
AnswerRe: How coding is involved here PinmemberSandeep Mewara10-Nov-08 6:30 
AnswerRe: How coding is involved here PinmemberJasonC7211-Nov-08 18:41 
General"Advanced" PinmemberSelvin25-Sep-08 2:56 
AnswerRe: "Advanced" PinmemberSandeep Mewara25-Sep-08 3:07 
GeneralRe: "Advanced" PinmemberManish Ranjan Kumar25-Sep-08 20:33 

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

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

| Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 25 Sep 2008
Article Copyright 2008 by Sandeep Mewara
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid