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.