Excel Filters from Report Studio Report

[vetteheadracer]

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.

[karthik.kadambi]

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