Showing posts with label ssrs. Show all posts
Showing posts with label ssrs. Show all posts

Monday, March 19, 2012

Data Processing Extension not visible

hello,

I have written a Custom Data Processing Extension for SSRS 2005.

The Report Server is in SharePoint integrated mode, this works perfect except for the extension.

When I want to set a DataSource in SharePoint (WSS 3.0), the extension is not in the ComboBox.

This works well on another server with the same extension.

The DLL file of that extension is copied in the reportserver bin folder.

I have added the references in the rsreportserver.config and rssrvpolicy.config (see below).

Code Snippet

rsreportserver.config

<Data>

<Extension Name="SPSLISTS" Type="ICom.ReportingServices.SharepointListsExtension.Connection,

ICom.ReportingServices.SharepointListsExtension" />

<Data>

Code Snippet

rssrvpolicy.config

This code is located inside the CodeGroup with Name="SharePoint_Server_Strong_Name".

<CodeGroup class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="SPSLISTS_CodeGroup"

Description="Code group for my SPS LISTS data processing extension">

<IMembershipCondition class="UrlMembershipCondition"

version="1"

Url="D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\ICom.ReportingServices.SharepointListsExtension.dll"

/>

</CodeGroup>

I already tried re-installing Reporting Services and the add-in for SharePoint but the problem remains.

Does anyone has an idea of what's wrong here?

Thanks in advance,

Tom

Found the solution, NTFS permissions needed to be set.

|||Hi Tom.

I was wondering if you could elaborate on your solution. I have run into this same problem and am unsure of what NTFS permissions you are talking about. Could you clear that up for me, as I think it would solve my problem as well. Thanks!

V

Tuesday, February 14, 2012

Data from a web service

I have a need to provide data, and ssrs looks like the ticket. The problem
is that the ss2k database is behind a firewall; I can get to it with a web
service that returns a dataset, but I dont see how to get ssrs to recognize
it.
Is that possible?
Thx, MarkIn RS 2000, we dont' have a web service data extension. This is on the list
for a future version.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"MarkAurit" <MarkAurit@.discussions.microsoft.com> wrote in message
news:23AF2B99-29F5-4B81-95DA-507815F4CF35@.microsoft.com...
>I have a need to provide data, and ssrs looks like the ticket. The problem
> is that the ss2k database is behind a firewall; I can get to it with a web
> service that returns a dataset, but I dont see how to get ssrs to
> recognize
> it.
> Is that possible?
> Thx, Mark