The XML Data Provider supports following options under the Connection section in Report Data Source dialog.
Connection Properties
- External file or URL: This field requires you to enter the path of an external XML source such as a local file or the http location of a file.
- Embedded: This field requires you to enter the path of the XML file to embed in the report. You can also enter the data manually or edit the data in selected XML file.
- Expression: This field requires you to enter the path expression. User can also enter the path expression in the Connection String.
Connection String
- xmldoc: Refers to a specific XML file located on either the file system or at a web-accessible location. For example,
xmldoc=C:\MyXmlFile.xml;
- xmldata: Provides specific XML data in the Connection String itself. For example,
xmldata=<people>
<person>
<name>
<given>John</given>
<family>Doe</family>
</name>
</person>
<person>
<name>
<given>Jane</given>
<family>Smith</family>
</name>
</person>
</people>;
- TransformationDoc: Refers to a specific XSLT file to apply to the XML data.
Note that elements in the Connection String must be terminated with a semicolon (;) character.