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.

Answer this question

Export to excel button

The Buffer
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
jkushiner
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
---

TA123

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
---

Export to excel button

Answer this question

Export to excel button

Hot Topic

SQL Server

Export to excel button

Export to excel button

The Buffer

jkushiner

TA123