Is this possible?
Trying to think of a way to create a Filter field in an Excel Spreadsheet when exporting from a Report Studio Report.
Any help appreciated.
If Prompts are filtering your Output you can just bring in either a ParamDisplayValue() or ParamValue().
If you are only restricting the show filters option for an Excel Output then create a conditional blockfor ReportOutput() and have values as 'XLWA' and 'spreadsheetML'. I think one of them is for Excel 2002 and the other for Excel 2007