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: Shortcut button back to document map

Anyone know of a way to provide a quick "back button" on each tab of
the excel export to go back to the document map tab?Bump
zach.bowling@.gmail.com wrote:
> Anyone know of a way to provide a quick "back button" on each tab of
> the excel export to go back to the document map tab?

export to excel from a report

Hi, I would like to have a button on my report to export it to excel (instead of having to choose the format from the toolbar and then press "export").
Is there a way to do it? I know that there is a parameter that I can add to the url for this but i don't know exactly how to add it to the current url from my report).
Thanks
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comsee my reply on "Nicknack" user query
Amarnath
"roy mm" wrote:
> Hi, I would like to have a button on my report to export it to excel (instead of having to choose the format from the toolbar and then press "export").
> Is there a way to do it? I know that there is a parameter that I can add to the url for this but i don't know exactly how to add it to the current url from my report).
> Thanks.
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>

Export to excel button

Hi, I would like to have a button on my report to export it to excel (instead of having to choose the format from the toolbar and then press "export").

Is there a way to do it? I know that there is a parameter that I can add to the url for this but i don't know exactly how to add it to the current url from my report).

Thanks.
Here is a slightly changed sample from the BOL:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Format=EXCEL4.0&rs:Command=Render

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||I didn't get how this help me?

i need to get the full url in order to add my EXPORT parameter to it.

I'm also working with oracle and the command "select @.@.servername as 'a'" did dont worked.

thanks
|||Parameters can simply be added after the report name as the following:

ReportName?ParameterName=SomeValue?AnotherParameterName=AnotherValue

@.@.ServerName is a global variable of TSQL not PLSQL, you will need the equivalent which is, AFAIK something with instance_Name, Like SELECT Instance_Name from V$Instance.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de