| Groups | Blog | Home |
sql server reporting services : File Share Data Processing Extension Sample
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! Jenny
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. 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 [quoted text, click to view] "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. [quoted text, click to view] > > 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! [quoted text, click to view] > 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? [quoted text, click to view] > > - 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. :-( [quoted text, click to view] > 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 [quoted text, click to view] >>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. [quoted text, click to view] >> 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 [quoted text, click to view] "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. > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |