Exporting in SSRS 2005

Hi,

I'm developing a web app in .NET 2.0 using SSRS 2000 and 2005. Some of the reports need to be exported directly to PDF when clicked, but the problem is in the fact that the user must select the parameters from the report manager window.

Is there any way to allow the direct export to PDF when generate is clicked, or to limit the options the user has to export to in the report manager.

P.S. If it is possible, I DO NOT want to accomplish this using code.

Thanks,

Hello,

Here's how to get rid of the other export options:

Navigate to {System Root}:\Program Files\Microsoft SQL Server\MSSQL.{RS_Instance_ID}\Reporting Services\ReportServer

Open rsreportserver.config in your favorite text editor

Search for <Render>

You should see the available rendering extensions here

<Extension Name="XML" ... />

<Extension Name="EXCEL" ... />

...

In order to just have PDF available, comment out all but the line for PDF

<!-- <Extension Name="XML" ... /> -->

<!-- <Extension Name="EXCEL" ... /> -->

...

Save the file and close it

Please note, that if you do this, these options won't be available to anyone in Report Manager.

Hope this helps.

Jarret

|||Jarrett. I also had need to do this and it worked. However, I now need to restore one of the ones I had removed. I uncommented out the one I want back, saved the file, and started up Report Manager. The options under export didn't change. The uncommented one didn't reappear. Any help would be appreciated. Thanks, Jim.|||Restart your SQL Server service and ReportServer service completely. Otherwise, check if you did not accidentally make a spelling mistake or something in the Config file. Eduard

Exporting in SSRS 2005

Hi,

I'm developing a web app in .NET 2.0 using SSRS 2000 and 2005. Some of the reports need to be exported directly to PDF when clicked, but the problem is in the fact that the user must select the parameters from the report manager window.

Is there any way to allow the direct export to PDF when generate is clicked, or to limit the options the user has to export to in the report manager.

P.S. If it is possible, I DO NOT want to accomplish this using code.

Thanks,

Hello,

Here's how to get rid of the other export options:

Navigate to {System Root}:\Program Files\Microsoft SQL Server\MSSQL.{RS_Instance_ID}\Reporting Services\ReportServer

Open rsreportserver.config in your favorite text editor

Search for <Render>

You should see the available rendering extensions here

<Extension Name="XML" ... />

<Extension Name="EXCEL" ... />

...

In order to just have PDF available, comment out all but the line for PDF

<!-- <Extension Name="XML" ... /> -->

<!-- <Extension Name="EXCEL" ... /> -->

...

Save the file and close it

Please note, that if you do this, these options won't be available to anyone in Report Manager.

Hope this helps.

Jarret

|||Jarrett. I also had need to do this and it worked. However, I now need to restore one of the ones I had removed. I uncommented out the one I want back, saved the file, and started up Report Manager. The options under export didn't change. The uncommented one didn't reappear. Any help would be appreciated. Thanks, Jim.|||Restart your SQL Server service and ReportServer service completely. Otherwise, check if you did not accidentally make a spelling mistake or something in the Config file. Eduard

exporting desktop MSDE to remote server Sql

What is the best tool for doing this? I have been using MSDE to create a
portal app on my desktop and now want to move the data from the MSDE db
locally to the remote server db. I can export the MSDE data but need a way
to get it to the remote sever and import it. Enterprise Manager seems to
be the tool of choice for this but I don't have it so I need another way.
Thanks!
Try WinSQL at http://www.synametrics.com/winsql. I have found to be the
best solution if Enterprise Manager is not available. It can move the
data as well as serve as a query tool.
Regards,
PM
Bob K. wrote:

> What is the best tool for doing this? I have been using MSDE to create a
> portal app on my desktop and now want to move the data from the MSDE db
> locally to the remote server db. I can export the MSDE data but need a way
> to get it to the remote sever and import it. Enterprise Manager seems to
> be the tool of choice for this but I don't have it so I need another way.
> Thanks!
>
|||hi Bob,
"Bob K." <bob1030@.hotmail.com> ha scritto nel messaggio
news:A2YLc.6720$eM2.877@.attbi_s51...
> What is the best tool for doing this? I have been using MSDE to create a
> portal app on my desktop and now want to move the data from the MSDE db
> locally to the remote server db. I can export the MSDE data but need a
way
> to get it to the remote sever and import it. Enterprise Manager seems
to
> be the tool of choice for this but I don't have it so I need another way.
you can have a look at Web Data Administrator,
http://www.microsoft.com/downloads/d...displaylang=en
which implements a Web interface where you can execute Transact-SQL scripts
and/or (partially) manage your databases...
other tools, both free and commercial can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442 ..
you can have a look at a free prj of mine too, available at the link
following my sign..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Export to CSV fails with 3rd party web app

From my web application, exporting to Excel works fine, but when I export to CSV and open with Excel I get 2 garbage characters. I can export the report just fine from the ReportServer.

Is there something special that needs to be done? Could I have an old file?

Could it be something in my report? We always have the following components:
-- textboxes in the page header and footer
-- page header refers to parameter values; page footer refers to globals
-- 2 date parameters and 1 hidden boolean parameters

We're running SQL 2005 Reporting Services, and I have SP2 installed.

(I write the reports, not the web app)

?t

The export failed from SSRS, so the issue is not in the ReportViewer control.
It turns out a report parameter and a field in the dataset had the same name.
SELECT *, bad=@.bad FROM Employees

Changing the parameter name fixed it.
SELECT *, bad=@.notBadAtAll FROM Employees

Export to CSV fails with 3rd party web app

From my web application, exporting to Excel works fine, but when I export to CSV and open with Excel I get 2 garbage characters. I can export the report just fine from the ReportServer.

Is there something special that needs to be done? Could I have an old file?

Could it be something in my report? We always have the following components:
-- textboxes in the page header and footer
-- page header refers to parameter values; page footer refers to globals
-- 2 date parameters and 1 hidden boolean parameters

We're running SQL 2005 Reporting Services, and I have SP2 installed.

(I write the reports, not the web app)

?t

The export failed from SSRS, so the issue is not in the ReportViewer control.
It turns out a report parameter and a field in the dataset had the same name.
SELECT *, bad=@.bad FROM Employees

Changing the parameter name fixed it.
SELECT *, bad=@.notBadAtAll FROM Employees