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

Export to html and print

Hi all,
i've created a print button for users to obviously print their reports. When
it's clicked, the webpage automatically renders the report into a html view.
The i've written some javascript 'window.print() actually ;)' so it
automatically begins printing.
But when i look to the report after it is printed, i see that when i have eg
15 columns, only the first three are printed. (so only the first page). Do i
have to add something specifiek so that it prints the entire page ? Because
everything is well rendered, it just doesn't print good.
Thanks in advance !
Kind regards,
Koen Vermeire
koen.vermeire@.gmail.comI think what you are doing is the same thing as if the user printed from IE
using the print functionality of IE. You only get the page that is currently
visible.
My suggestion if you can wait is to do so. By the middle of this month SP2
will be released and it includes client side printing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:A2248AB1-0F1E-4C08-9DE4-13BB7D7BF489@.microsoft.com...
> Hi all,
> i've created a print button for users to obviously print their reports.
When
> it's clicked, the webpage automatically renders the report into a html
view.
> The i've written some javascript 'window.print() actually ;)' so it
> automatically begins printing.
> But when i look to the report after it is printed, i see that when i have
eg
> 15 columns, only the first three are printed. (so only the first page). Do
i
> have to add something specifiek so that it prints the entire page ?
Because
> everything is well rendered, it just doesn't print good.
> Thanks in advance !
>
> Kind regards,
> Koen Vermeire
> koen.vermeire@.gmail.com|||Well, the thing is, i am making this stuff because i'm currently finishing my
internship. So i wanted to deliver a complete solution to my company. But as
you said, SP 2 will be out soon, so i'll guess it'll be beter to wait for
that.
Thanks for the very fast response ;)
Kind regards,
Koen Vermeire
"Bruce L-C [MVP]" wrote:
> I think what you are doing is the same thing as if the user printed from IE
> using the print functionality of IE. You only get the page that is currently
> visible.
> My suggestion if you can wait is to do so. By the middle of this month SP2
> will be released and it includes client side printing.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Koen" <Koen@.discussions.microsoft.com> wrote in message
> news:A2248AB1-0F1E-4C08-9DE4-13BB7D7BF489@.microsoft.com...
> > Hi all,
> >
> > i've created a print button for users to obviously print their reports.
> When
> > it's clicked, the webpage automatically renders the report into a html
> view.
> > The i've written some javascript 'window.print() actually ;)' so it
> > automatically begins printing.
> >
> > But when i look to the report after it is printed, i see that when i have
> eg
> > 15 columns, only the first three are printed. (so only the first page). Do
> i
> > have to add something specifiek so that it prints the entire page ?
> Because
> > everything is well rendered, it just doesn't print good.
> >
> > Thanks in advance !
> >
> >
> > Kind regards,
> > Koen Vermeire
> > koen.vermeire@.gmail.com
>
>

Export to Excel - merge and centre issue

hi
I am exporting a report from SQL 2000 reporting services into excel and by
default all columns have merge and centre clicked. Can i change this so this
property is not checked which makes it easier for users to do things like
sorting etc.
Any help would be appreciated.
Thanks heaps
RidhimaIs this Excel export or CSV export? With CSV the default is Unicode which
Excel then merges (or doesn't split into different columns). In 2000 the
only thing you can do if this is the case is have a link the user clicks
that then uses jump to URL and you have it render in CSV ASCII. In RS 2005
you can configure it to export CSV in ASCII format as the default.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ridhima Sood" <RidhimaSood@.discussions.microsoft.com> wrote in message
news:511E9718-8B0F-4A84-AF8D-71DA3598E104@.microsoft.com...
> hi
> I am exporting a report from SQL 2000 reporting services into excel and by
> default all columns have merge and centre clicked. Can i change this so
> this
> property is not checked which makes it easier for users to do things like
> sorting etc.
> Any help would be appreciated.
> Thanks heaps
> Ridhima