SQL Server Reporting Services - data extension 'XML'

Hot Topic

Results to Text showing NULL...yuck
sql 2005 updating table definition with 'large' amounts of data - timeout
Msg 3910 Transaction context in use by another session.
Solution Explorer in SQL Server Management Studio
set up problems by sql express edition 2005
How to change login in linked server (From Sql Security to Integrated Sec)
Error while importing Text file using Import Export Wizard
AS400 password request
Unable to set Default Schema for a group
Management Studio Still will not install

SQL Server

SQL Server 2000 and SQL Server 2005 on the same computer
Apply buttons not submitting changes
SQL Task - passing parameters
problem in using xp_cmdshell to run dts package
Error when calling a Sub report (Jump to report)
SQL Server Connectivity Problem
Unique Integer IDs
HELP US MICROSOFT: SYNCH BETWEEN SQL EXPRESS AND SQL MOBILE
Connecting SQL2000 problem
Query problem - TIPOS IN ()

SQL Server Reporting Services - data extension 'XML'

The reports based on XML is perfectly displayed in development Environment.

But than uploaded to Server, the following occurs:

  • An error has occurred during report processing.
    • An attempt has been made to use a data extension 'XML' that is not registered for this report server.

Help needed, thank you.

Answer this question

SQL Server Reporting Services - data extension 'XML'

  • TDAVISJR

    Thank you for the answer!

    Is there are any way to revoke this limitation

    XML is a great technology, and it does not look like a "big deal" for Microsoft to let developers use XML as the DataSource for the Reporting, even in Express Edition.

    Thank you very much again,

    Alfred.

  • Christopher Diggins - MSFT

    Thank you, Robert, but , yes it present . Is there restriction By Microsoft to use XML as data source In SQL Express

    <Data>

    <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/>

    </Data>

  • ToddGibbs

    By default, the RSReportServer.config file of RS 2005 should contain the registration for the Xml data extension in the <Data> section:

    <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions" />

    Is it present in your case

    -- Robert



  • satyanarayana150916

    Yes, SQL Express Advanced Edition is restricted to relational data sources. Check this link for more details: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

    -- Robert



  • SQL Server Reporting Services - data extension 'XML'
Answer this question