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