Sharepoint/WSS Reporting Services Integration woes

Posted by mhollers on Stack Overflow See other posts from Stack Overflow or by mhollers
Published on 2009-07-02T09:48:22Z Indexed on 2010/03/13 3:07 UTC
Read the original article Hit count: 826

Filed under:

sharepoint

|

reporting-services

|

sql-server-2005

after a number of failed attempts i seem to have successfully installed the Reporting services add-in to my WSS farm. However, I seem to be missing most of the enhanced functionality eg no report library template, no report center site template. the only additional functionality available is the report viewer web part.

background: 2 server WSS 3.0 farm with CA (Central admin) WFE (web front end) and reporting services addin installed on 1, and SQL05 SP2 with Reporting services (RS) and all databases installed on other. I have a VM environment set up and have rolled this back and repeated a number of times.

I have configured RS within CA and activated 'Report Server INtegration Feature'. Within the 'site settings' I have a 'Reporting Services' heading with a 'manage shared schedules' item/link, not sure if there should be other options?

I was of the understanding that to view reports within sharepoint i could either create a new site using the 'report center' template or add a report library to an existing site, neither of which seems available

I am at a loss as to what to do, as all online information seems to do with dealing with installation issues/errors, which i seem to have eventually got past

© Stack Overflow or respective owner

Related posts about sharepoint

SharePoint 2010 MSDN Labs

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Eric Ligman, from Microsoft, posted a great blog post this week listing all of the SharePoint 2010 Virtual Labs that are available from Microsoft. His blog entry is here: http://blogs.msdn.com/b/mssmallbiz/archive/2012/03/13/sharepoint-server-2010-msdn-virtual-labs-available-to-you-online-plus-more-sharepoint-2010-resources… >>> More
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hos

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hosting, Michigan Sclera, a Microsoft Hosted Services Provider Partner, is offering key Service Offerings around the Microsoft SharePoint Server 2010 stack. Specifically – if you’re looking for SharePoint… >>> More
SharePoint Personalization Site Links - Les liens personnalis?s des MySite SharePoint

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Nous avons vu dans les articles pr?c?dents comment agr?menter les pages de recherche afin de permettre une meilleure adoption du produit par les utilisateurs. Il existe une autre fonctionnalit? de Microsoft Office SharePoint Server 2007 (MOSS) qui permet aussi de personnaliser un peu le MySite des… >>> More
Auditer une ferme SharePoint - Assurer le bon fonctionnement de SharePoint

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Dans le cadre de la bonne gestion de son environnement SharePoint, il est utile de faire un contr?le de son installation afin d'assurer le bon fonctionnement des fermes et donc, la meilleure disponibilit? pour les usagers. Dans ce but, nous verrons comment auditer sa ferme facilement et les traitements… >>> More
Using jQuery and SPServices to Display List Items

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I had an interesting challenge recently that I turned to Marc Anderson’s wonderful SPServices project for. If you haven’t already seen or used SPServices, please do. It’s a jQuery library that does primarily two things. First, it wraps up all of the SharePoint web services in a nice little AJAX wrapper… >>> More

Related posts about reporting-services

Subtotal error on calculated field in a Reporting Services Matrix

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a Reporting Services report that has two row groups: Category and SubCategory. For columns it has LastYearDataA, ThisYearDataA, LastYearDataB, ThisYearDataB. I added two columns (one for A and one for B) to handle an expression calculation (to show a percentage different from LastYear to… >>> More
Reporting Services: Two Tables One Sum

as seen on Stack Overflow - Search for 'Stack Overflow'
My report is as follows: One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data) The second table is a variance report for data that has been shipped… >>> More
Sharepoint/WSS Reporting Services Integration woes

as seen on Stack Overflow - Search for 'Stack Overflow'
after a number of failed attempts i seem to have successfully installed the Reporting services add-in to my WSS farm. However, I seem to be missing most of the enhanced functionality eg no report library template, no report center site template. the only additional functionality available is the report… >>> More
SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

as seen on Server Fault - Search for 'Server Fault'
When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. Error Code 800706B3 This error appears before I can even attempt to connect to an SSRS instance. In… >>> More
SQL Server Reporting Services Data Extention

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello! So... here's my story: I'm trying to create a SQL server data extension (to be precise, I'm trying to get some sample code to run) (SSRS2005). I've done the following: Placed the extension assembly into the ReportServer/bin folder. Placed the assembly into the Private Assemblies folder… >>> More