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]

Working with Cascading Parameters in Reporting Services

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]

Adding Embedded Code to a Report

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]

Integrating Reporting Services with Web Applications - Report Items TreeView

This article will demo the use of Reporting Services SOAP API to integrate with a web application. We will begin by creating a new Web Project in VS 2008 and configuring the web.config so we can authenticate using impersonation. Next, we will reference the ReportingService2005 web services proxy object. Then enter some code to render a list of reports from within the Report Catalog. [More]

Creating a Shared Data Source in Reporting Services

This article will provide an example of how to create a Shared Data Source and publish it to your Report Server. You may use the data source while developing reports in Report Designer and Report Builder 3.0 tools. For this example, we will be using SQL Server Business Intelligence Development Studio 2008. [More]