Results 1 to 6 of 6

Thread: Can I surpress exports from reporting services

  1. #1

    Thread Starter
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Can I surpress exports from reporting services

    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.
    Attached Images Attached Images  
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

  2. #2
    Fanatic Member
    Join Date
    Jun 2004
    Location
    All useless places
    Posts
    917

    Re: Can I surpress exports from reporting services

    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 property
    Code:
    myReportViewer.ShowExportControls = False
    and that works for me. I'll have to see if there is a setting in the report manager or not.

  3. #3

    Thread Starter
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: Can I surpress exports from reporting services

    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. 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?
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

  4. #4

    Thread Starter
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: Can I surpress exports from reporting services

    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
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

  5. #5
    Fanatic Member
    Join Date
    Jun 2004
    Location
    All useless places
    Posts
    917

    Re: Can I surpress exports from reporting services

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

  6. #6

    Thread Starter
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: Can I surpress exports from reporting services

    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.
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width