R&R V10 SQL

[Anne_Phillips]

We want to program a front end so that the user can choose certain fields from a SQL view and then those fields be passed to R&R runtime so that an export to Excel is created. In otherwords, we want the CSV file to only contain those fields selected by the user. ____As far as I can see if I write a report then I can^t control which columns are exported and the order of the columns at run time. ____eg I write a report to export 10 fields. At run time - the user chooses fields 3, 1 and 6 to export only - how can I achieve this?

[kfleming]

You might be able to get there by using R&R^s Open Scripting feature to create a report on the fly that would contain only the selected fields. You can use a script file name in the RI_REPORT field of the control file. Check out the Open Scripting information in the help file for details on what the script would need to contain.____Kathleen__R&R Support