I am building a dashboard to capture error reports/QA testing, and there is a field in the data that will generate a SQL Select script that points to the problem areas in the data.
For example, if a job is run and 40 fields cause the job to fail, it'll populate a field in an audit table (that QV pulls from) with a SQL script that would select the 40 fields in the DW.
Would it be possible to download that script as a .sql file on a button press? Right now I have it as part of a pivot table, and I understand that I could just copy the cell's contents, but I was wondering if there was an easier way to do it.
