x

how to use xml data extension as datasourse in SSRS

We have an issue with reporting services 2005. I have to genererate a report with many fields in simple columns. But each column will have subreport to produce the values since each column is not related to one another, but there is a one common field that connect to the main Table. This report is overview of the data that is in Database to show in a summary format.

With Sub reports I can create a normal parameter (int/string datatype) from main parent report, but this will keep the database server busy until the report renders all the data. And my teamlead doesnot want to keep the server busy and instead he suggested me to use 'xml Data Extension' datasource.

By using this way the report is connected to xml datasource and not directly to the database, and all data is fetched in XML file (generic file) one time. I didn't catch is point exactly. Please note the xml data extension will take the parameter values in XML format and as well produce the result in XML format, we will later transit the xml data into html using xslt.

Could anyone please help me what exactly is 'xml data extension' data source and how it is used.
more ▼

asked Aug 01, 2011 at 12:46 AM in Default

reddy gravatar image

reddy
11 2 2 2

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x559
x94
x29

asked: Aug 01, 2011 at 12:46 AM

Seen: 1231 times

Last Updated: Aug 01, 2011 at 12:46 AM