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: Saturday, February 01, 2014 2:14 PM
Points: 100, Visits: 435
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: Friday, April 11, 2014 7:44 AM
Points: 96, Visits: 346
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