Click to See Complete Forum and Search --> : Can I surpress exports from reporting services
FunkyDexter
Jul 16th, 2008, 06:33 AM
We've got a suite of reports that our users access using reporting services. When each report is run the task bar has a bunch of options including the ability to export the data to various file formats. Some of our reports contain information that would be valuable to our competitors and we've suffered from data theft before so, unsurprisingly, the directors aren't keen on users being able to export from the reports. Is there any way I can surpress the export option? Screen shot below to show what I mean.
rjv_rnjn
Jul 16th, 2008, 03:32 PM
I use the report viewer control on my aspx(ASP.Net web) page to show the reports. There in while initializing the report viewer I use the propertymyReportViewer.ShowExportControls = False and that works for me. I'll have to see if there is a setting in the report manager or not.
FunkyDexter
Jul 17th, 2008, 05:27 AM
Thanks. That's pointed me in the right direction but I don't think I'm there yet.
I googled for report server and ShowExportControls and found this page (http://forums.msdn.microsoft.com/en-US/vsreportcontrols/thread/7251f401-b332-4072-b9cd-2a4a337dd4f0/). I've used the technique described in the third post and added the visible="false" attribute to all the export types. When I accessed the reporting web page again the options were all still there. I assume this was just because it hadn't picked up the new config so I've tried restarting the service but that didn't make a difference. Does anyone know how I get the reporting services to pick up changes to the config file?
FunkyDexter
Jul 17th, 2008, 06:32 AM
Scratch that. I just retried it and now the export options are gone. I guess the settings were cached somewhere and needed some time to flush out or something.
This achieves what I want because users can no longer export because they can't select a format but it's not ideal because the export button and the drop down are still visible so it looks a little odd. If anyone knows a better way of achieving this I'd still like to here about it so I'm leaving this unresolved. In aperfect world I'd like a way of setting this on a report by report basis (the current solution removes the options from all reports). I'm therefore leaving the thread unresolved.
Cheers
rjv_rnjn
Jul 18th, 2008, 08:25 AM
In aperfect world I'd like a way of setting this on a report by report basis (the current solution removes the options from all reports).I found this thread (http://forums.microsoft.com/forums/ShowPost.aspx?PostID=3631199&SiteID=1) in one of MSDN forums and it seems you can't do what you want on a report to report basis if you're running the reports from report server.
FunkyDexter
Jul 18th, 2008, 08:31 AM
Damn. Thanks for your rjv_rnjn, it's been most helpful.
I think what we're going to have to do, then, is remove any sensitive info from the reports - not exactly an ideal solution but it'll have to do.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.