In this session we'll show you how to create a Reporting Action using Analysis Services 2012 Cube Designer. We'll explain what a Reporting Action is, how to create one in SSAS 2012 and finally demonstrate how to render a SQL Server Reporting Services report by executing the Reporting Action from Excel. [More]
Recently, I've had a few requests for how to display a TreeView list of Report Parts from SQL Server Reporting Services Report Server Web Services. This article will demonstrate how to query a list of Reports, Datasets and Report Parts using Report Server Web Service EndPoints. For this session we'll be using the ReportingServices2010 EndPoint. [More]
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.
In this session we'll show you how to change a Sparkline series fill color when value(s) are either positive or negative. This session demonstrates how to work with Sparkline’s using SQL Server Report Builder 3.0 for authoring and designing the report. [More]
1. October 2012
In this article we will describe how to programmatically add a new Folder and Properties to the catalog list in Reporting Services. We will be using the CreateFolder and FindItems methods for this example. [More]
This article describes how to render a list of data sources and dataset's from with a Report Definition (.RDL) file, while using the SQL Server Reporting Services Web Services. [More]
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]
Microsoft® SQL Server® 2008 R2 August Community Technology Preview and SQL Server® 2008 R2 Report Builder 3.0. [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]
1. October 2012
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]