Tuesday, May 22, 2007

Use XML file as data source in SSRS

SSRS support using an XML file as your data source; you will need to choose XML as the type and supply the file path (ex: c:\test.xml) in the connection string field.

You can also make the XML file name dynamic. you will just need to use expressions in the connection string field (ex: = Parameters!XMLFileName.Value)

But please remember that you will need to add "fields" manually while configuring the data set. When you add fields in the dataset configuring page, this will allow you to use these fields in the report(ex: when setting textbox value use expression like this one"Fields!FirstFieldName.Value").

1 comment:

Anonymous said...

Good post.