Page 1 of 1

Stop Export to Excel from Report viewer

Posted: Wed Oct 10, 2012 1:48 am
by mihiri1
Hi,

I want to stop users from exporting the report to any Excel formats.
Is that Possible?
If so what should be the approach?
I use SS 2011.1.919

Thanks

Re: Stop Export to Excel from Report viewer

Posted: Wed Oct 10, 2012 7:10 am
by HighAley
Hello.

You could use next options to disable Excel exports:

Code: Select all

StiOptions.Viewer.Windows.Exports.ShowExcel = false;
StiOptions.Viewer.Windows.Exports.ShowExcel2007 = false;
StiOptions.Viewer.Windows.Exports.ShowExcelXml = false;
Thank you.

Re: Stop Export to Excel from Report viewer

Posted: Wed Oct 10, 2012 7:26 am
by mihiri1
Hi, Thanks.

Where should this be set? On an event?

Re: Stop Export to Excel from Report viewer

Posted: Thu Oct 11, 2012 7:47 am
by HighAley
Hello.

These are the static options. They should be set before initializing of the Viewer.

Thank you.

Re: Stop Export to Excel from Report viewer

Posted: Fri Oct 12, 2012 3:54 am
by mihiri1
Thanks, It did work.

Re: Stop Export to Excel from Report viewer

Posted: Fri Oct 12, 2012 4:32 am
by Andrew
Hello,

Great!