Robert Bruckner's Reporting Services & Power View Blog
Power View, Tips and Tricks for SQL Server Reporting Services, RDL Report Design, Business Intelligence
Reporting and SQL Data Services
SQL Data Services (SDS) was shown at PDC in October, utilizing a REST based interface. As described...
Author: Robert Bruckner Date: 03/15/2009
Dynamic Drilldown in Reports and Charts
Just a quick post to reference two interesting reads about designing dynamic drilldown in reports:...
Author: Robert Bruckner Date: 03/15/2009
Tablix – The Matrix Revolution
Tablix is the new underlying flexible data region and grouping structure introduced in Reporting...
Author: Robert Bruckner Date: 03/06/2009
Subreport Usage
In a previous post I showed how to quickly find reports that use custom report items (CRIs). The...
Author: Robert Bruckner Date: 03/03/2009
RS Tracer
Have you ever wondered what API calls Report Manager or Management Studio are performing to...
Author: Robert Bruckner Date: 02/24/2009
Report Surfer
I wanted to give some props to MVP Grant Paisley who has setup a site called Report Surfer, where...
Author: Robert Bruckner Date: 02/23/2009
The Ultimate Guide to Color Scales / Conditional Formatting
I recently provided a tip to my Australian colleague David Lean to successfully solve a small report...
Author: Robert Bruckner Date: 02/20/2009
BIDS Helper, RS Scripter
I wanted to point out two Reporting Services utilities built by our MVPs and user community that you...
Author: Robert Bruckner Date: 01/28/2009
Take Another Look at CSV Rendering in RS 2008
If you used the CSV renderer in previous releases of Reporting Services, you might want to take...
Author: Robert Bruckner Date: 01/21/2009
Better Report Viewing in Visual Studio 2010
We plan to release significantly updated and improved versions of both the Winforms and ASP.NET...
Author: Robert Bruckner Date: 01/20/2009
Report Server Optimizations
The fourth and final technical note "Reporting Services Performance Optimizations" in our series on...
Author: Robert Bruckner Date: 01/14/2009
Optimizing Reports - Show the Right Set of Data
You are probably now thinking, of course my report shows the right data! Ok, but is it fast...
Author: Robert Bruckner Date: 01/13/2009
Report Performance Optimization Tips (Subreports, Drilldown)
In a previous posting, I explained the new ExecutionLog2 view in Reporting Services 2008: how to...
Author: Robert Bruckner Date: 01/09/2009
What Kind of Reports are Published / Which Use Custom Report Items?
As an administrator of a report server, you may occasionally ask yourself the question of what kind...
Author: Robert Bruckner Date: 01/09/2009
ExecutionLog2 View - Analyzing and Optimizing Reports
There are several options for monitoring performance of a report server. The fourth article in our...
Author: Robert Bruckner Date: 01/06/2009
Acronyms
BIDS SQL Server Business Intelligence Development Studio CRI Custom Report Item MDX Multi...
Author: Robert Bruckner Date: 01/02/2009
Custom Report Item
Custom Report Item in Reporting Services 2005 This server extensibility feature introduced in...
Author: Robert Bruckner Date: 12/31/2008
Using Teradata's .NET Data Provider
Reporting Services 2008 RS 2008 includes full support for Teradata-based report models. You can...
Author: Robert Bruckner Date: 12/26/2008
Reporting Services 2008 Information Aggregator
Want to get an overview, recommendations for good books and other resources, and the latest...
Author: Robert Bruckner Date: 12/23/2008
RDL 2008 Specification
Our documentation team made the latest RDL specification available on the Reporting Services site:...
Author: Robert Bruckner Date: 11/26/2008
Trendlines (Calculated Series) in Reporting Services Charts
One of the new chart features in Reporting Services 2008 is the ability to add chart series...
Author: Robert Bruckner Date: 11/09/2008
Technical Note Series on Reporting Services Performance and Scalability
Over the past few months, I contributed to a series of technical notes by my esteemed colleagues...
Author: Robert Bruckner Date: 11/04/2008
Speaking at SQL Server Energy Conference
The SQL Server Energy 2008 Conference takes place in Vienna, Austria, on November 25th and 26th. The...
Author: Robert Bruckner Date: 11/01/2008
See You at PASS Summit ...
The PASS Community Summit 2008 is a don't-miss event for Microsoft SQL Server professionals. Whether...
Author: Robert Bruckner Date: 11/01/2008
All Things Data Visualization (Sparkline Reports, Silverlight Charts)
My colleagues Sean Boon and Alex Gorev recently started their own blogs with focus on data...
Author: Robert Bruckner Date: 10/29/2008
Reporting from Data in the Cloud (aka SSRS and SDS at PDC)
One of the demos shown at Monday's PDC keynote by Ray Ozzie and Bob Muglia was Reporting Services...
Author: Robert Bruckner Date: 10/27/2008
Do You ▖ Unicode in PDF?
One of the changes we included in Cumulative Update #1 for SQL Server 2008 (CU1 download link) is...
Author: Robert Bruckner Date: 10/27/2008
Microsoft Chart Controls for .NET Framework 3.5 Released!
One of the projects the data visualization group within the Reporting Services team has been working...
Author: Robert Bruckner Date: 10/25/2008
What DataSet Query Text Is Executed?
In a previous posting, I discussed dataset execution order in Reporting Services. In this posting, I...
Author: Robert Bruckner Date: 10/25/2008
Report Builder 2.0 Released!
Microsoft SQL Server 2008 Report Builder 2.0 RTM (build 10.00.1600.60) is now available on Microsoft...
Author: Robert Bruckner Date: 10/17/2008
Using Analysis Services Parent-Child Hierarchies in Reports
One of the questions that I answer somewhat frequently, is about recursive groupings in Reporting...
Author: Robert Bruckner Date: 10/15/2008
Expression-Based Dynamic Drillthrough Actions
The Reporting Services demo during the "BI Power Hour" session at the Microsoft Business...
Author: Robert Bruckner Date: 10/14/2008
Repeat Header / Keep Header Visible in Tables in RS 2008
You selected "Repeat header rows on each page" or "Keep header rows visible while scrolling" in the...
Author: Robert Bruckner Date: 10/13/2008
See You at Business Intelligence Conference 2008 ...
The 2nd Annual Microsoft Business Intelligence Conference has lots of great information and...
Author: Robert Bruckner Date: 10/01/2008
Report Builder 2.0 - RC1 Release
Report Builder 2.0 RC1 is now available on Microsoft Download Center. Use this link for download....
Author: Robert Bruckner Date: 08/25/2008
On-Demand Report Processing in Reporting Services 2008
You may have heard by now that the report processing engine of Reporting Services 2008 works...
Author: Robert Bruckner Date: 08/12/2008
Visual Studio 2008 SP1 as a Prerequisite
If you had Visual Studio 2008 RTM (or a Beta of SP1) already installed on your machine, the...
Author: Robert Bruckner Date: 08/12/2008
Dataset Execution Order
A Reporting Services report can contain multiple dataset definitions. By default, datasets are...
Author: Robert Bruckner Date: 08/07/2008
SQL Server 2008 RTM
SQL Server 2008 was released to manufacturing (RTM) today (see press release). You can download it...
Author: Robert Bruckner Date: 08/06/2008
Using Group Variables in Reporting Services 2008 for Custom Aggregation
Introduction SQL Server 2008 Reporting Services (SSRS 2008) features an on-demand report processing...
Author: Robert Bruckner Date: 07/21/2008
Scale-Up Improvements in Reporting Services 2008
A few months ago, leading up to the release of RC0 of SQL Server 2008, I was involved in working...
Author: Robert Bruckner Date: 07/20/2008
Finally starting a blog ...
I have been putting this off for a while. But not out of concern with sharing myself in public -...
Author: Robert Bruckner Date: 07/20/2008