Deploying Reports/Models with WSS 3.0 integrated mode

Using BIDS, and trying to deploy to a newly created reporting server. I can deploy the report but cannot figure out how to display it in the WSS 3.0 teamsite. My document library settings allow 'new report builder report' and 'new report datasource' but I don't see how to upload reports built in BIDS for use in the Sharepoint site.

Models that I created in BIDS I cannot deploy at all. Just get an error saying 'this operation is not supported in sharepoint integrated mode.

Anyone else worked through the deployment of existing datasources and reports yet to a WSS 3.0 reporting server in integrated mode?

If I just upload an RDL file to the document library and try to display it, I get the following:

System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.InvalidCastException: Specified cast is not valid.
at Microsoft.ReportingServices.Library.Security.get_UserToken()
at Microsoft.ReportingServices.SharePoint.Server.SharePointSecurity.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc, String itemPath)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2006.GetPermissions(String Item, String[]& Permissions)

Which authentication mode did you choose, on the Reporting Services integration page in Central Admin? SP2 CTP2 only supports Windows Authentication mode.|||

I've changed back to the windows mode. And I'm a little better off. After publishing the RDL file in my shared documents, I'm only lacking a datasource. Can't quite figure out how to get that there.

Maybe it's time to upgrade my visual studio 2005 with the Sharepoint package for wss 3. Would that enable me to publish reports again directly from the BIDS project?

Where I'm stuck then is putting both data models and datasources up on the sharepoint site using the reporting services integrated mode.

|||

Solved the datasource issue by just creating it in the Sharepoint document library. Then hooked it up to the report I had loaded in manually using the 'Upload' menu. For the report you will find a 'manage datasources' context menu item off the report object.

Now if someone comes up with the answer of how to get the data models up to my Sharepoint server so that the report builder can be called on, I'll be in pig heaven.

|||

You can upload an .SMDL file into SharePoint, and it will "just know" that it's a Reporting Services model (because of the file extension).

In CTP3, Models are fully supported -- you can design in Model Designer, autogen from SharePoint, manage drillthroughs and model item security, and launch Report Builder from a model's ECB menu.

|||

Slowly but surely it is coming together. Now, the magical CTP3, when will that be posted?

I have a suggestion for CTP3 if you have not thought of it. These RS documents display context menus in the shared document library. But if I do a search, the search results page does not give me the ability to use the Report/Model/Datasource with the same contextual choices. Same idea when I display things with the 'dependent items' choice (which is a slick feature in and of itself). And the last display I'd expect more of would be the page that opens when you click on the found file would offer the same contextual choices. (reports open fine, but models don't link to the report builder and open)

Now wouldn't that be a totally seamless feature that would sweeten the end-user experience?

BTW, I'm still constructing datasources for each model or report I upload to a document library. Can I simply copy a datasource (extension=rds, or ds) and just change the extension to rsds before uploading it?