show report item only in export to excel

[Yves]

dear support team,

is it possible to show/hide items from the report when exporting to excel (or powerpoint)? when exporting I need to show an extra information block of the report, is something like this possible?

kind regards

[Squall]

Hi, 

The only way to get the export format in the report is if you use the web report viewer with user function. The user function can be used in Bindings to conditionally set the report item visibility.

public static string ExportFormat()
{
     return System.Web.HttpContext.Current.Request.QueryString["ExportFormat"];
}

Don't forget to reference System.Web assembly in your reports class library.

SN