Is there a way to run a report just to get the dataset and send it to an FTP server, without having to format a report?
I like the reporting format, but many of the reports that I would like to make are simply SQL queries that would be FTPed to a server and stored as CSV files. My problem is that if I try to make a traditional report and do this using the table component, some of my datasets have 40+ rows and this seems to make the table component very cumbersome. In fact it seems to start to slow down on me at around 25 columns.
I am only using the table component because I don’t know how else to get the dataset from the query to spit out into a CSV file via the report’s scheduling mechanism.