Report Builder Report Wizards
Report Builder 3.0 provides wizards to allow you to quickly create reports.
SSRS Development
Learn SSRS development with tutorials, tips, and best practices for building, deploying, and optimizing SQL Server Reporting Services.
Report Builder Table or Matrix Wizard
The Table or Matrix Wizard guides you through creating a report step-by-step. This topic will create our first report using the wizard.
Report Builder Chart Wizard
The Chart Wizard guides you step-by-step through creating a report that contains a chart. This topic will create a chart using the wizard.
Report Builder Map Wizard
The Map Wizard guides you step-by-step through creating a report that contains a map. This topic will create a map using the wizard.
Building a Report from Scratch
This section covers building a report from scratch using Report Builder.
Report Builder Report Headers
This topic will walk through the steps for adding the report header to a report.
Report Builder Report Footers
This topic will walk through the steps for adding the report footer to a report.
Report Builder Report Body
This topic will walk through the steps for creating the report body.
Report Builder Deploying Reports
This section will provide an overview of the options for deployment in Report Builder 3.0.
Highlighting repeating groups in SSRS 2008 R2 charts
In a typical bar chart, the height of the bars represents the value of the data along the X axis and the Y axis represents the category of the data point. All these values can be classified in logical groups depending upon the logic used for analysis. One
SSRS 2008 R2 KPIs with bullet graphs
Key Performance Indicators are typically displayed in a scorecard with stop light indicators, which are in the either red, amber or green light icons. The limitation for these kind of indicators is that you can see the actual and target values in two diff
Creating a Reporting Services Histogram Chart for Statistical Distribution Analysis
Typically transactional data is quite detailed and analyzing an entire dataset on a graph is not feasible. Generally such data is analyzed using some form of aggregation or frequency distribution. In this tip we look at how Histogram Charts can be used fo
How to handle empty values in a line chart in SSRS
When displaying non-continuous data on a line chart the chart is not displayed correctly. In this tip we look at how to handle empty points to correct this problem.
Building Calculated Members for a SSRS Report using MDX
Step by step process to build a calculated member using MDX, SSRS and SSAS.
Customize Dropdown List in SSRS Report using a SSAS Cube Data Source
I have a requirement to develop a report that uses a SQL Server Analysis Services Cube as a data source. The report must allow the user to select the desired month from a dropdown list. The dropdown list must include the last 24 months of available data
SSRS Report Parts Versus Sub Reports FAQ
I'm trying to decide on a development strategy to satisfy the reporting needs in my organization. I would like to increase our efficiency in responding to report requests, while minimizing our maintenance burden. Two topics that I would like to dig in t
SSRS Linked Reports Example
Reports outputs that differ on parameter values are a very common report design scenario in SQL Server Reporting Services. A common business scenario is where each SSRS report output needs a different caching / security / storage configuration. In the abs
Getting Started with Report Parts in SQL Server Report Builder 3.0
One of the many new features in SQL Server Reporting Services 2008 R2 is one called Report Parts. You can publish parts of a report then reuse those parts in other reports. In this tip I will demonstrate how to take advantage of this new feature.
Hiding parameters and using default parameter values in SSRS reports
Many times in a parameterized report, we may come across situations where we need to execute a report using a fixed parameter value depending upon the users group. In such cases, displaying a list of parameters to the user would not make sense. Also a par
Getting Started with Report Builder 3.0 Shared Datasets
I have many reports that allow users to select a year filter from a dropdown list. Is there a way that I can define this query once then reference it in multiple reports? In this tip we walk through how this can be done.
Getting Started with Sparklines in SQL Server 2008 R2 Reporting Services
I'm looking at several new visualization features in SQL Server 2008 R2 Reporting Services and the sparkline looks like something that I could really use. In this tip, we look at how to use the sparkline in Reporting Services reports.
Getting Started with Data Bars in SQL Server Reporting Services
I'm looking at several new visualization features in SQL Server 2008 R2 Reporting Services and the data bar looks like something that I could really use. In this tip we cover how this can be used in your Reporting Services reports.
Maps in SQL Server 2008 R2 Reporting Services
I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehou
SSRS Lookup, LookupSet and MultiLookup Functions
I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.