Jump to content

Use CSV as datasource - CSV changes


lswaddle
Go to solution Solved by lswaddle,

Recommended Posts

Hello, 

 I was wondering how to use a CSV as a datasource, I've managed to get it working on the server, but whenever I make changes to the CSV these are not shown in the report. 

I've tracked this down to whenever I publish report it will also save a copy of the CSV file to the server, which I'm assuming it then looks at. 

How can I instead have it look at an XML without it needing that 'local' copy? 

I've tried making use of file//pathtofile, but this causes the same problem. 

Any help would be appreciated. 

 

EDIT: What is also strange to me, is when I preview in studio even though the report is looking at the XML file stored on the server, whenever I run this it shows the changes in the CSV file no problem. 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

  • Solution

So I figured out where I was going wrong. 

I shouldn't have ever been using the T: or file:\  instead I need to make use of the actual server that the file was stored on so \server2folderfile.csv this has now worked and I can update the file freely. 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...