This is a migrated thread and some comments may be shown as answers.

show report item only in export to excel

1 Answer 21 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Yves
Top achievements
Rank 1
Yves asked on 14 Nov 2012, 10:11 AM
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

1 Answer, 1 is accepted

Sort by
0
Squall
Top achievements
Rank 1
answered on 14 Nov 2012, 12:32 PM
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
Tags
General Discussions
Asked by
Yves
Top achievements
Rank 1
Answers by
Squall
Top achievements
Rank 1
Share this question
or