SSRS report with xml file as data source

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » SSRS report with xml file as data source

SSRS report with xml file as data source

Rate Topic

Display Mode

Topic Options

Author

Message

var05

Posted Thursday, March 21, 2013 3:31 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:06 AM
Points: 96, Visits: 419

Hi All,

I have a .xml/text file which contains certain values that are being dynamically updated by users. I wanted that file to reside in a shared folder where users will have access.

Whenevr the user changes the values,the same has to update in SSRS reports...

Any help pls!!

Thanks!

Post #1433658

//Ravi

Posted Friday, March 22, 2013 1:18 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 13, 2013 1:17 PM
Points: 77, Visits: 265

I would use SSIS to export data to a DB, access or SQL. You can schedule this to run at any frequency you like.

Then I would have SSRS access the modified data. You can use SQL state to compare the new data.

------------
:)

Post #1434492

« Prev Topic | Next Topic »

Permissions