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!

1

Watusi (SSRS Management Tools Changes for Katmai)

For Katmai we are considering the removal of namespace management (folders, reports, data sources, models) from the Reporting Services Add-in for SQL Server Management Studio (SSMS). In other words, we are considering removing the ‘Home’ folder under the Reporting Server node in SSMS. Why the change? Customer feedback and usage data indicates that Report Manager and/or SharePoint…

10

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…

0

We Were Dead Before the Ship Even Sank (SSRS Reports on SharePoint Lists)

Now that we have released the SSRS integration in MOSS 2007 / WSS in SQL Server 2005 Service Pack 2, people often ask whether they can build reports against data in SharePoint lists. Although this functionality is not built into SSRS, if you are willing to go pick up a 3rd party component, I have…

6

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…

26

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…

14