Tribal Thunder (SharePoint White Papers Available)

After many months of working on getting them posted, I’m excited to let you know that two whitepapers on the integration between SQL Server Reporting Services and SharePoint are now available. SQL Server 2005 Integration with Microsoft SharePoint Products and Technologies Troubleshooting Integration with SQL Server 2005 and Microsoft SharePoint Technologies Enjoy!


At the End of Paths Taken (Modifying Where Clause when All Parameter Values are Selected)

  With the return of “Select All” in Service Pack 2, all multi-value parameters allow the user to pick all of the available values. But what if you want to remove the predicate from your WHERE clause instead of generating a long set of values in the IN predicate? You can accomplish this is via an expression-based query…


Pocket Symphony (Enabling SSRS Feature in non-default Site Collections)

After installing the Reporting Services Add-in for Integration with SharePoint, you may find that the Reporting Services features are not visible in your SharePoint web sites. Why does this happen? Because when the add-in is installed, it is only activated for the sites in the default Site Collection. Steps to resolve: Bowse to the ‘Home’ or…

Candy Apple Grey (Installing SSRS and Windows Vista)

It’s a bit tricky to get Reporting Services (including the report server that comes with SQL Express with Advanced Services) to work on Windows Vista. The key is to turn on the right set of IIS components in the “Turn Windows features on or off” tool in the Vista control panel. Here is the list of…


Propeller (SP2 is Released!)

It’s been a long time coming, but SQL Server 2005 Service Pack 2 is now available. See

Wincing the Night Away (Tips for SSRS in SharePoint Mode)

Here is some useful information about using SSRS in SharePoint Integrated mode (included with SP2): Installing the SharePoint Add-In If you plan to upgrade from a previous version of the add-in, you should uninstall the previous add-in then install the new one. After installing the new one, you will need to perform the RS configuration…


The Destroyed Room (Hyperion Essbase and Reporting Services White Paper)

One of the new Reporting Services features of SQL Server 2005 Service Pack 2 is integration with the Hyperion Essbase 9.3. Similar to building reports on SQL Server Analysis Services or SAP NetWeaver BI, this integration includes a new .NET data extension and a new query designer for Report Designer. If you are interested in how…


Today! (Cleaning up Reporting Services SharePoint Add-In Setup Problems)

Some people have had problems during installation of the new Reporting Services Add-in for Microsoft SharePoint. If the add-in setup fails while to add the Reporting Services feature to the sites, some of your SharePoint sites will no longer work.  You can tell if the custom action failed by looking for a file named RS_SP_#.log in…