SSRS report with xml file as data source

• var05

  Hall of Fame

  Points: 3011

  More actions

  March 21, 2013 at 3:31 am

  #270068

  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!

• //Ravi

  SSCrazy

  Points: 2612

  More actions

  March 22, 2013 at 1:18 pm

  #1599968

  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.

  ------------
  🙂