Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS report with xml file as data source Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 3:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 1, 2014 8:41 AM
Points: 101, Visits: 437
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
Posted Friday, March 22, 2013 1:18 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 2, 2014 1:47 PM
Points: 97, Visits: 363
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 »

Add to briefcase

Permissions Expand / Collapse