Hi, our company does LOTS of ad hoc reports and therefore don’t need to always use the automation feature. We have a need for some reports to go to a .csv (Comma Separated Values) format, but most like this exported report to have quotes around the characters. This is especially useful in text fields that have all numerics or start with zeros, to ensure they don’t come over as number. I notice the only option when exporting the results of a query to .csv is to export data to a .csv file using the one click export option. It doesn’t allow you to specify any other options on how the export should go, for example saying characters should have quotes or to include header rows, similar to how Microsoft Access would do. I wonder if there is an option outside of moving the query to automation to get quotes around character fields on .csv exports? If not, could this be some type of enhancement? I have the once click export set to prompt me for location every time. Maybe if that item is clicked, there could be additional options around that to include the quotes for characters and even if the header row should exist or not?
Just wanted to get some ideas. Thanks!