Thursday, March 29, 2012

Exporting reports

Is there any way to turn off (or hide) the export function when
viewing a report though report manager. There are certain reports
that we would only like people to view through report manager, we do
not want them to be able to export into PDF, Excel, etc..
Thanks,Steve,
You should be able to do this by creating a custom stylesheet for these
reports. By default, these are located in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\styles. Create a copy of
htmlviewer.css, (i.e. noexport.css), and change the .ToolbarExport display
from "inline" to "none. Then, you can use the rc:stylesheetcommand=noexport
parameter to tell your webbrowser to display the viewer with that particular
stylesheet. for instance, you would use render the report like this:
http://myserver/reportserver/?/MyReport&rc:stylesheet=noexport&rs:Command=Render&rs:Format=HTML4.0
"Steve" <steven.cooper@.infocision.com> wrote in message
news:aa4429ef.0409230514.7ec55869@.posting.google.com...
> Is there any way to turn off (or hide) the export function when
> viewing a report though report manager. There are certain reports
> that we would only like people to view through report manager, we do
> not want them to be able to export into PDF, Excel, etc..
> Thanks,|||"Joe Krill" <jmk@.endowmentcapital.com> wrote in message news:<OQeONWNpEHA.3424@.TK2MSFTNGP12.phx.gbl>...
> Steve,
> You should be able to do this by creating a custom stylesheet for these
> reports. By default, these are located in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\styles. Create a copy of
> htmlviewer.css, (i.e. noexport.css), and change the .ToolbarExport display
> from "inline" to "none. Then, you can use the rc:stylesheetcommand=noexport
> parameter to tell your webbrowser to display the viewer with that particular
> stylesheet. for instance, you would use render the report like this:
> http://myserver/reportserver/?/MyReport&rc:stylesheet=noexport&rs:Command=Render&rs:Format=HTML4.0
>
> "Steve" <steven.cooper@.infocision.com> wrote in message
> news:aa4429ef.0409230514.7ec55869@.posting.google.com...
> > Is there any way to turn off (or hide) the export function when
> > viewing a report though report manager. There are certain reports
> > that we would only like people to view through report manager, we do
> > not want them to be able to export into PDF, Excel, etc..
> >
> > Thanks,
Thanks. I don't think I was veru clear. What I meant, is there any
way in Report Manager to hide the export dropdown box, or gray it out.
They will have access to report manager, but I want to remove the
options from report manager. Preferrable hide them off the UI.

No comments:

Post a Comment