Stop Export to Excel from Report viewer

[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

[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.

[mihiri1]

Hi, Thanks.

Where should this be set? On an event?

[HighAley]

Hello.

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

Thank you.

[mihiri1]

Thanks, It did work.

[Andrew]

Hello,

Great!