Custom Report Item

Custom Report Item in Reporting Services 2005 This server extensibility feature introduced in Reporting Services 2005 (RS 2005) provides the ability to develop custom report items for embedding in reports.  Examples of resources available that provide insights into how one can build custom report item solutions include: documentation overview, sample, and a great MSDN magazine article by…

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

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

Tablix – The Matrix Revolution

Tablix is the new underlying flexible data region and grouping structure introduced in Reporting Services 2008.  Among other features, it enables asymmetric layouts, as demonstrated in the thumbnail screenshot below.  If you use a list, table, matrix, chart, gauge, or custom report item in RS 2008, you are really using a tablix beneath the covers. …

2

Kerberos Authentication and Reporting Services

When deploying Reporting Services in an environment that requires more than one server, such as a scale-out deployment or a deployment in a server farm, you may need to configure Kerberos authentication. Kerberos is particularly important when you require domain accounts to authenticate users but don’t need to pass user credentials to the database that…

2

Visual Studio 2010 Report Viewer Available

In case you missed it in the recent wave of SQL Server, Visual Studio, and Office release announcements, Visual Studio 2010 was released in mid April and includes significantly enhanced ReportViewer controls. In server mode, the ReportViewer control can connect to and leverage the features of SQL Server 2008 R2 report servers, as well as…

2

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 Denny and Lukasz on http://sqlcat.com/. The technical notes provide guidance on how to build, deploy, and optimize large scale SQL Server Reporting Services (SSRS) environments.  We derived some of the best practices from internal as well as external enterprise SSRS deployments. So…

2

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 tablix properties dialog, but it doesn’t seem to work as expected?  You might want to try the following four steps if you are using a “table”-style layout: in the grouping pane, click on the small triangle and select “Advanced…

2

Report Builder 2.0 – RC1 Release

Report Builder 2.0 RC1 is now available on Microsoft Download Center.  Use this link for download.  RC1 delivers improvements in the following areas compared to RC0: Easy to use wizards for creating table, matrix and chart data regions. Support for directly opening and editing reports stored on the report server. Support for using server resources…

2

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 on is building stand-alone ASP.NET and Windows Forms Chart Controls for the .NET Framework 3.5 and Visual Studio 2008, similar to what has been already available as built-in chart functionality in SQL Server Reporting Services 2008.  These stand-alone chart controls can…

2