Security and OWC

[Hennie]

I display a pivot table in a .asp page. The pivot table's data source is a
OLAP cube from SQL server 2000.

I want to give the users the ability to use the "Export to Excel"
functionality within the pivot table for printing purposes.

a. Is there a way from preventing the user to change the filter selection
once in Excel?

b. Is there a way to remove the data from the excel pivot table (once the
"Export to MS Excel" in the pivot table on the asp page has been clicked) so
that when it has been emailed to an external party the pivot table won't
have access to the data source?

 

[Alvin Bruney]

a. You can do so with script by targetting the appropriate filter object.
b. One easy way to do this is to set the connection string property to empty
at the time of export. Without a valid connection setting, the pivot table
will not be able to retrieve data. There are other ways to do this by the
way but that is what comes to mind at the moment.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[Joao Almeida]

Hy, my friend.

Connect to www.microsoft.com
Look for Office Web Component Tool Pack

Inside of this tool you will see many codes that you use to create all
functionalyties that you wish!


Good work, see ya!
Joao Almeida
MCT - MCDBA - MCSD.NET - MCP - MCTS SQL Server 2005