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.

Export to Word or RTF in SQL Reporting services

does any know if SQL server reporting services will be offering a RTF format
export or Word export' I need this function - it force me to use crystal
reports (ARRGH!!)
Or does anyone know of a provider that made one?I know SoftArtisans (www.softartisans.com) is working on something in this
area. The feature did not make it on the list for SQL 2005.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chicago Dave" <Chicago Dave@.discussions.microsoft.com> wrote in message
news:767BAA7C-EE40-4858-BF0E-2CA3F22C032C@.microsoft.com...
> does any know if SQL server reporting services will be offering a RTF
> format
> export or Word export' I need this function - it force me to use crystal
> reports (ARRGH!!)
> Or does anyone know of a provider that made one?
>

Export single table in web data administrator

Hi,
I am using the "Web Data Administrator" on the MS SQL Server (2000 I think)
database provided by my ISP.
I use the Export function every so often so that I can make a copy on my
local SQL server, (I have no access to DTS on the ISP server).
However, lately, the sheer amount of records I have over 30 or so tables,
causes this to fail. Does anyone know of a built in proc or some t-sql I can
use to emulate the export function of the "web data administrator" but limit
it to individual tables?
Many thanks for any help.
Xavier,
I understand that you are getting the data transferred to your local SQL
Server, not the table structures. Perhaps you could use bcp, something
like:
bcp MyDb.dbo.BigTable OUT D:\BigTable.DAT -S ISPSQLServer -T -n
FTP the file internally then run something like:
OSQL -S DEVSQLServer -E -Q "USE MyDb TRUNCATE TABLE BigTable"
bcp MyDb.dbo.BigTable IN D:\BigTable.DAT -S DEVSQLServer -T -n
FWIW,
RLF
"Xavier" <Xavier@.discussions.microsoft.com> wrote in message
news:D8228881-1C5C-45A7-91AE-14645590B5F2@.microsoft.com...
> Hi,
> I am using the "Web Data Administrator" on the MS SQL Server (2000 I
> think)
> database provided by my ISP.
> I use the Export function every so often so that I can make a copy on my
> local SQL server, (I have no access to DTS on the ISP server).
> However, lately, the sheer amount of records I have over 30 or so tables,
> causes this to fail. Does anyone know of a built in proc or some t-sql I
> can
> use to emulate the export function of the "web data administrator" but
> limit
> it to individual tables?
> Many thanks for any help.