Create a Custom Report Template for SQL Server Reporting Services (SSRS) 2012

In this article we'll show you how to create a custom Report Template for use with SQL Server Reporting Services. What is a Report Template? A Report Template is a custom defined .RDL file which you save to the ReportProject folder of SQL Server Data Tools (SSDT). The custom Report Template will render in the list of available Report Templates to choose from within SSDT. The benefit is Reusability and Brand Standards for authoring business specific reports. [More]

Spice up your Pie Chart by setting the PieDrawingStyle property

This article we will describe how to enhance a Pie Chart by using the SoftEdge or Concave value, using SQL Server 2008 Reporting Services. These values are available only on a 2D Pie Chart. The image below illustrates both SoftEdge and Concave styles, respectively. We will be using Report Builder 3.0 for this example. [More]

Working with a Recursive Hierarchy Group in SQL Reporting Services 2008

This article explains how to create a recursive hierarchy group, which organize data in a report to include multiple hierarchical levels. This is helpful when you want to display hierarchical data in a report. For example: employees in an organizational chart, or product subcategory in a product list. [More]

Using Parameters in Report Builder 3.0

Creating and using parameters in Report Builder 3.0. In Report Builder 3.0, parameters are used to specify the data to use in a report, connect related reports together, and vary report presentation. To design a report that uses parameters effectively, you must understand how parameters and dataset queries work together, how parameters and expressions work together, how parameters can be managed on the report server for a published report, and what questions a report is designed to answer. [More]

Introduction to Report Builder 3.0 Part 1

Introduction to Report Builder 3.0

With the new release of Microsoft SQL Server 2008 you will find available, a seperate download Report Builder 3.0 for Reporting Services. Report Builder 3.0 is a report authoring tool that runs on your local computer. You can create many different types of reports to meet your reporting needs, such as sales, marketing, and financial reports, by using combinations of tables, matrices, lists, and charts. You can then manipulate your data by filtering, grouping and sorting, and by adding expressions and parameters. After your report looks the way you want, you can publish it to a report server or a SharePoint site, where others within your organization can read it, or you can save it to your local computer. [More]