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.

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting in different Formats

Is there a way to hide the address bar, while exporting the reports to PDF or
Excel. Currently when i click export it opens up a new window with the
address bar containing the whole URL including the parameters i am passing.It is possible when you write your custom code, using web services. You gan
then render the page to any format, without having to show the page..
"prankster" wrote:
> Is there a way to hide the address bar, while exporting the reports to PDF or
> Excel. Currently when i click export it opens up a new window with the
> address bar containing the whole URL including the parameters i am passing.
>