Report Surfer

I wanted to give some props to MVP Grant Paisley who has setup a site called Report Surfer, where you can directly view, share, and download sample Reporting Services reports.  I met Grant a few months back when he visited Redmond.  He was very interested in reports I had built for the RS 2005 chart…

1

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 design challenge with tables and charts that use conditional formatting.  The specific goal was to dynamically calculate and assign a color shade so that the minimum value present in the data is shown red, the average value yellow, and the maximum value…

2

BIDS Helper, RS Scripter

I wanted to point out two Reporting Services utilities built by our MVPs and user community that you may find very useful. BIDS Helper is a CodePlex project: http://www.codeplex.com/bidshelper In past releases, the focus has been on significantly enhancing Analysis Services and Integration Services BIDS design experiences.  Version 1.4 was just released, and for the first time BIDS…


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 another look in RS 2008.  We listened to your feedback: not only does CSV rendering consume significantly less resources and is faster in most cases, the CSV data output is generally more useful as well if you use complex report layouts…


Better Report Viewing in Visual Studio 2010

We plan to release significantly updated and improved versions of both the Winforms and ASP.NET Report Viewer controls in Visual Studio 2010.  This is going to include the long awaited local mode support for the new report processing engine, originally released with SQL Server Reporting Services 2008.  Most importantly, this provides RDL 2008 features (e.g. tablix, enhanced charts,…


Report Server Optimizations

The fourth and final technical note “Reporting Services Performance Optimizations” in our series on Building and Deploying Large Scale SQL Server Reporting Services Environments is now available on SQLCAT.com.  The focus of this final technical note is on how to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.

1

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 (enough)?   My esteemed colleague Dean Kalanquin started blogging recently.  He has been working in databases for a long time, and has gained great experience and knowledge by working on several different areas of SQL Server…


Report Performance Optimization Tips (Subreports, Drilldown)

In a previous posting, I explained the new ExecutionLog2 view in Reporting Services 2008: how to utilize it to measure report execution performance, identify report candidates for optimizations, and verify the impact of the latter.  I also included two tips at the bottom of that posting, that I want to call out explicitly as a separate…

2

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 of reports are published in terms of their particular feature usage.  For example:   ·         Usage of Custom Report Items (CRIs)You plan to upgrade from RS 2005 to RS 2008 and there are CRI controls installed on your…

2

ExecutionLog2 View – Analyzing and Optimizing Reports

There are several options for monitoring performance of a report server.  The fourth article in our technical note series on performance and scalability covers information for optimizing entire report servers.  Besides performance counters, analyzing report execution log data in particular can help answer questions such as, which reports might be good candidates for caching, how many reports were returned from…

7