Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Report Builder Tutorial


By:   |   Last Updated: 2011-07-12   |   Comments (13)   |   Related Tips: 1 | 2 | 3 | 4 | > Reporting Services Report Builder

Read the tutorial!

Report Builder is Microsoft's report authoring tool for business users.  It has a simple and intuitive user interface that is similar to Microsoft Office.  This tutorial will cover what you need to know to get started authoring reports with Report Builder 3.0, which was released with SQL Server 2008 R2.

Report Builder 3.0 provides the capability to design, execute and deploy SQL Server Reporting Services 2008 R2 reports.  The user interface has been streamlined to allow business users to become proficient at authoring reports very quickly.  Report Builder 3.0 has just about all of the features that are available in the Report Designer in Business Intelligence Development Studio (BIDS), which is the developer tool for authoring reports.

The tutorial consists of the following sections:

  • Installing Report Builder 3.0
  • Getting Started
  • Report Wizards
  • Building a Report from Scratch
  • Deploying Reports

You can either use the outline on the left or click on the arrows to the right or below to scroll through each of these topics.

Read the tutorial!



Last Updated: 2011-07-12


next webcast button


next tip button



About the author




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Wednesday, September 25, 2013 - 4:51:56 PM - Raymond Barley Back To Top

Permissions can be setup at the folder level or individual report level; usually you want to do it at the folder level if possible. You do this from the Report Manager.  

 

Start reading the tutorial here: http://www.mssqltips.com/sqlservertutorial/249/site-settings/


Wednesday, September 25, 2013 - 1:35:32 PM - Benjamin Back To Top

Thanks for all of your help. I've another question.

 

How does SSRS handle security when it comes to individual accessing specific reports? For example, I am a Math Department Chairman and that I to only see or access Math students on reports that I pull up and not Biology students (or other departments) within the college Student Information Systems or SSRS environment?

 

 

Thanks,

 

Ben

 

 


Monday, May 20, 2013 - 10:13:26 AM - Raymond Barley Back To Top

Check your dataset query and make sure it's using the parameter values in the WHERE clause.

 

I don't know how to change the background color of the parameter display.


Monday, May 20, 2013 - 9:43:10 AM - Benjamin Back To Top

I have a dataset pulling from a query with the following data elements: Name, StartDate, EndDate, CourseName, ClassSections, and Location. I later created a report with three parameters: StartDate, EndDate and CourseName from the same dataset and data source. The report is group on the CourseName. When I run the report and select the different date ranges and coursename, the report displayed all of the data regardless of the selected parameter values.

What am I doing wrong or what do I need to do to get the data to display base on the selected parameters values?

Lastly, how do I change the background color of the parameters displayed sections of a report?

Thanks as always!

Benjamin

 


Monday, May 06, 2013 - 10:06:47 AM - Benjamin Back To Top

Hi Ray,

My Report Manager and SQL Management Studio (SSDT) are on a domain and are accessed via a remote connection. There's a problem rendering my reports in (i.e. in PDF, CSV, Excel, etc) formats on the domain. Note: MS Office suite is not available on the domain environment.

What do I need to do to get a successfully rendered and viewable report? 

Please advise.

Thanks,

Ben

 

 


Friday, April 05, 2013 - 10:55:26 AM - Raymond Barley Back To Top

It sounds like your report is using a shared dataset but the shared dataset isn't in your project.  If that's the case then add the shared dataset to your project.


Friday, April 05, 2013 - 10:30:34 AM - Benjamin Back To Top

Hi Ray,

An error has occurred during my report process in MS SQL Server 2012 using SSDT. Error in connecting to the shared dataset. Cannot create a connection with datasource of shared dataset or the DataSource1 does not exist. I've tried many options but the problem does seem to go away. what do you advice?

Thanks in advance for your feedback!


Friday, February 15, 2013 - 11:51:27 AM - Raymond Barley Back To Top

SQL Server 2012 doesn't install Business Intelligent Development Studio; instead you get SQL Server Data Tools.  You can launch it from the SQL Server 2012 program group.  It will be very familiar.


Friday, February 15, 2013 - 9:06:04 AM - Benjamin Back To Top

Thanks Ray for your prompt response, it is appreciated. I'll implement it and provide you with feedback.

By the way, MS SQL Reporting Server 2012 was acquired and installed successfully. However, I don't see the Business Intelligent Development Studio environment for report authoring. I'm of the opinion that a connection will be made to the Report Sever in Management Studio to allow the building and design of reports.

Could you please some insights on the above?

 


Thursday, February 07, 2013 - 8:06:23 PM - Ray Barley Back To Top

Add a parameter to your dataset query; e.g. WHERE PERCENTAGE_COLUMN = @PERCENTAGE_PARAMETER.  This will add a parameter to your report.  Add another dataset where the query will return the list of percentages; you could return them from a table or just use a select statement like 

select .05 as PERCENTAGE_OPTION

union all

select .10

union all

select .20

Go to the PERCENTAGE_PARAMETER and set it up so that it gets the list of available values from a query.  When you run the report a dropdown will be shown with the list of percentages.

For the user defined percentage don't setup the parameter so that it gets the list of available values from a query; instead a text box will be shown when you run the report allowing the user to type in a value


Thursday, February 07, 2013 - 12:34:09 PM - Benjamin Back To Top

I want to create two reports that will be filtered on a predetermined list of percentages (e.g. 5%, 10%, 20%) and another with a user defined percentage  using Microsoft SSRS. How do I get around doing this?


Tuesday, October 02, 2012 - 8:52:51 AM - Ray Barley Back To Top

Change your query so that you have a column that is the result of A / (A + B) then use that column in the line chart.


Monday, October 01, 2012 - 11:45:05 AM - Logan Kirk Back To Top

I am trying to put together a basic percentage chart, and have created 2 indicators, A and B. I need to produce a simple line chart showing A as a monthly percentage of the whole. i.e A over (A+B)

I know this may sound easy and where it's a doddle in Excel, I can't seem to get the syntax right in SQL, not being a seasoned user.


Learn more about SQL Server tools