Posted 4 August 2017, 2:55 pm EST
I have a decent amount of reports that run different query strings. I have added an Export to Excel button onto the viewer toolbar. When I export to excel the entire report is exported; header, footer, etc. I am currently using the XLSExport feature. Is there a way to export just the SQL select field names and the data associated with the fields? If possible could you please provide code.
I understand how to use the spreadbuilder and statically add the field names and data, but I would like to make this dynamic so that when a different report loads different information is populated into excel according to the SQL query strings.