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