File Share Data Processing Extension Sample

Hi all, I am very new to this Reporting Services and I want to follow this
sample that comes with SQL Server 2005 Beta. However, I tried everything
according to the documentation (build the sample, deploy it by modifying the
config files, etc.). Unfortunately, when I create a new report (using the
Report Wizard) in Visual Studio 2005, I still cannot see the File Share
Information.
Searching this newsgroup pointed me to this
http://blogs.msdn.com/bryanke/archive/2004/05/14/132110.aspx#148541
However, this does not help me either.
Any help is greatly appreciated!
Thanks a lot!
JennyHi Jenny,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to deploy
FsiDataExtension and then use it in the Report Manager. If I have
misunderstood your concern, please feel free to point it out.
Based on my knowledge, here is a sample in Reporting Services 2000 but I am
not sure whether it is available in SQL Server 2005 Reporting Services.
For SQL Server 2005's issue, please post the question in the link below
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
For SQL Server 2000 Reporting Services, you could follow the steps below as
described in MSDN Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/ht
m/rss_sampleapps_v1_16g2.asp
- Copy Microsoft.Samples.ReportingServices.FsiDataExtension.dll to the
report server. The default location for report server extensions is
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin.
- Copy the assembly to Report Designer. The default location for
extensions for Report Designer is C:\Program Files\Microsoft SQL
Server\80\Tools\ReportDesigner.
- Add the following entry to both the RSReportServer.config and
RSReportDesigner.config files under the Data element.
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
- To enable the generic query designer for the sample data processing
extension, add the following entry to the RSReportDesigner.config file
under the Designer element.
<Extension Name="FSI"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael
Thanks for the reply. Please see my questions inline. Thanks in advance!!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you would like to deploy
> FsiDataExtension and then use it in the Report Manager. If I have
> misunderstood your concern, please feel free to point it out.
Yes you're right.
> Based on my knowledge, here is a sample in Reporting Services 2000 but I am
> not sure whether it is available in SQL Server 2005 Reporting Services.
> For SQL Server 2005's issue, please post the question in the link below
> http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
> cid=us
It's available and the steps look the same to me! Anyway, I have posted my
question in that beta newsgroup as well. Thanks!
> For SQL Server 2000 Reporting Services, you could follow the steps below as
> described in MSDN Online
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/ht
> m/rss_sampleapps_v1_16g2.asp
> - Copy Microsoft.Samples.ReportingServices.FsiDataExtension.dll to the
> report server. The default location for report server extensions is
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\bin.
> - Copy the assembly to Report Designer. The default location for
> extensions for Report Designer is C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner.
I interpreted 'Copy the assembly' as 'copy the dll' as in the previous step.
Is this correct?
> - Add the following entry to both the RSReportServer.config and
> RSReportDesigner.config files under the Data element.
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> - To enable the generic query designer for the sample data processing
> extension, add the following entry to the RSReportDesigner.config file
> under the Designer element.
> <Extension Name="FSI"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
>
I did all the above plus the steps in 'To configure code access security for
the sample'. I didn't know where exactly to put the CodeGroup info in the
config files unfortunately. I have tried a few spots and none succeeds. :-(
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>|||Hi
For you questions
>>I interpreted 'Copy the assembly' as 'copy the dll' as in
>>the previous step. Is this correct?
Yes, I copied Microsoft.ReportingServices.Interfaces.dll from C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Extensions\FsiDataExtension\cs\bin\Debug to the
destination.
>> I did all the above plus the steps in 'To configure code access security
for
>> the sample'. I didn't know where exactly to put the CodeGroup info in
the
>> config files unfortunately. I have tried a few spots and none succeeds.
:-(
snippet from my RSReportServer.config in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer for your reference.
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
</Data>
snippet from my RSReportDesigner.config file in C:\Program Files\Microsoft
SQL Server\80\Tools\Report Designer for your reference.
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions" />
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
</Data>
<Designer>
<Extension Name="SQL"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="ODBC"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="FSI"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
</Designer>
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi there
Thank you for your help, but what I wanted was where to put the following
code group info in both the rssrvpolicy.config and rspreviewpolicy.config.
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="FSICodeGroup"
Description="Code group for my FSI data processing extension">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin\Microsoft.Samples.ReportingServices.FsiDataExtension.dll"
/>
</CodeGroup>
Thanks again and I appreciate your help!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi
> For you questions
> >>I interpreted 'Copy the assembly' as 'copy the dll' as in
> >>the previous step. Is this correct?
> Yes, I copied Microsoft.ReportingServices.Interfaces.dll from C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Samples\Extensions\FsiDataExtension\cs\bin\Debug to the
> destination.
> >> I did all the above plus the steps in 'To configure code access security
> for
> >> the sample'. I didn't know where exactly to put the CodeGroup info in
> the
> >> config files unfortunately. I have tried a few spots and none succeeds.
> :-(
> snippet from my RSReportServer.config in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer for your reference.
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
> oft.ReportingServices.DataExtensions"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
> osoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
> soft.ReportingServices.DataExtensions"/>
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> </Data>
> snippet from my RSReportDesigner.config file in C:\Program Files\Microsoft
> SQL Server\80\Tools\Report Designer for your reference.
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
> oft.ReportingServices.DataExtensions" />
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
> osoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
> soft.ReportingServices.DataExtensions"/>
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> </Data>
> <Designer>
> <Extension Name="SQL"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="FSI"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
> </Designer>
> If you have any questions or concerns, don't hesitate to let me know. We
> are always here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Oh I see! Thanks for your help. I finally see the File Share Extension in
the list, but when I want to do more with that, I got this error:
"The designer extension FSI could not be loaded. Check the configuration
file RSReportDesigner.config." [OK]
Am I still missing something?
Thanks a lot!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> I have attached rssrvpolicy.config and rspreviewpolicy.config for your
> reference.
> Put the <CodeGroup > like other <CodeGroup> does will be OK. Something like
> this
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Dundas_Strong_Name"
> Description="This code group grants
> Dundas assemblies. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
> 10043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E
> 3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF444734
> 8D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C
> 3AF35FF3DD87578630ED13FE12CBDBC"
> />
> </CodeGroup>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="FSICodeGroup"
> Description="Code group for my FSI data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner\bin\Microsoft.Samples.ReportingServices.FsiDa
> taExtension.dll"
> />
> </CodeGroup>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights|||Actually, I have figured it out. I got the Assembly name wrong. Once I
fixed it, I could see it in the list and load it as well. The report preview
looks good too. :-)
Unfortunately, I couldn't deploy the report. The Report Server cannot be
started for unknown reasons. When I browse http://localhost/ReportServer,
the error is
"The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) "
What did I do wrong? I have tried re-setting these config files but it
still doesn't work. :-(
rssrvpolicy.config
rsreportserver.config
Please help!! Thanks!!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> I have attached rssrvpolicy.config and rspreviewpolicy.config for your
> reference.
> Put the <CodeGroup > like other <CodeGroup> does will be OK. Something like
> this
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Dundas_Strong_Name"
> Description="This code group grants
> Dundas assemblies. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
> 10043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E
> 3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF444734
> 8D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C
> 3AF35FF3DD87578630ED13FE12CBDBC"
> />
> </CodeGroup>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="FSICodeGroup"
> Description="Code group for my FSI data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner\bin\Microsoft.Samples.ReportingServices.FsiDa
> taExtension.dll"
> />
> </CodeGroup>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights|||Hi Jenny,
The error message seems to indicate that you do not set congifuration file
rssrvpolicy.config and rsreportserver.config correctly. Please double check
configuration files again and my attachment file is just a sample file for
your reference. You cannot use them directly.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.