Charts in a Tablix cell don’t work for me… but I’ve see these nice demos where they do…

Problem: You may have learned about sparklines or you want to add a chart to your Tablix.  You either copy/paste your working(!!!) chart into the tablix and then you preview and you get: "The chart ‘Chart1’ has a detail member with inner members.  Detail members can only contain static inner members." Solution: In a Tablix…

0

High Availability – Frequently Asked Questions about Failover Clustering and Reporting Services

In SSRS high availability is achieved through a Scale-out deployment that is placed behind a Network Load Balancer (NLB).  The NLB is then responsible for routing requests to Report Server nodes that are responding to requests.  High Availability Documentation Reference: http://msdn.microsoft.com/en-us/library/bb522745.aspx However, many customers are interested in using Windows Failover Clustering with SSRS, since this…

0

Building a robust setup experience with Reporting Services

This post is intended for ISVs or Product Development organizations who are planning to integrate Reporting Services into their product.   Over the years I have seen a number of products do this and some get it right and some encounter issues.   The part of the problem I’d like to focus on is recommendations for building…

0

InternalCatalogException, ASSERT, or NullReferenceException when using a Custom Security Extension

We have seen multiple customers with issues when customizing the Security Extension Sample (2005, 2008) that is available on http://www.codeplex.com/. This is the sample that demonstrates how to create a Forms Authentication solution with SQL Server Reporting Services. There are two scenarios which are the primary sources of the problems: Scenario 1: “Anonymous” access Many…

1

IIS Troubleshooting for SQL Server 2005 Reporting Services

Over the years, we have seen a number of IIS related issues that cause trouble for users who deploy SQL Server 2005 Reporting Services.  We have tried to resolve these in the MSDN Forums on a case by case basis.  Now we have compiled the common issues with IIS into a single KB Article along…

1

Several blogs I would keep on my reading list…

Recently I have had little time to devote to blogging, but I did want to pass along a couple of references that I tend to provide to customers, partners, and Microsoft internal folks as they dig deep into SSRS. Robert Bruckner has a great blog which offers many tips on SSRS, especially focusing on report…

0