Microsoft® SQL Server® 2008 R2 August Community Technology Preview and SQL Server® 2008 R2 Report Builder 3.0. [More]

This article will demo using an XML Data Source type in Reporting Services 2008. We will then consume three different web service methods – simple web service method, parameter based method and a method that returns a dataset. [More]

This is the continuation of Introduction to Report Builder 3.0 Part 1. This article will show you how to create your first report (SalesByFiscalYear) using Report Builder 3.0, and how to pulish the report to your Report Server. [More]

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

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]

In this post we will discuss changing the format of report items or properties based on the data in the report. We will show how build conditional expressions. For example: changing a row background color based on a field value. [More]

For this post we will walk through the steps in creating a custom assembly and referencing it from Reporting Services 2008. After we reference the assembly we will can the call the static (shared) method from a texbox field, using a custom expression. [More]

Cascading parameters are used to organize and limit the number of available values for the user. For example, you may have one parameter that filters a product category, and the second parameter used to list products related to product category. In this post we will walk through the steps of building a report and with query parameters for both product category and subcategory items. Then we will develop individual datasets to provide values for the cascading parameters. We will be using Report Builder 2.0 for this demo, but you may use the concepts presented below, while designing a report using BIDS. [More]

Reporting Services provides the ability to add references to embededed VB.NET code from within the report. You can use this feature to create reusable functions that are called more than once in a report. This post walks you though the steps needed to add embedded code to your reports. [More]

This article will provide you with a tip on how to define your own palette for charts, using Reporting Services 2008. [More]