Groups | Blog | Home
all groups > sql server reporting services > july 2004 >

sql server reporting services : Excel export


Renaud Langis
7/23/2004 7:19:20 PM
Hello,

I am having a problem when exporting a report to Excel. I am using the
SQL RS web service to render a report.

It seems that the report is always rendered using parameters default
values. It is not using parameters that i pass to the service. I am
having this problem only when rendering in Excel format. PDF is
working ok.

Anyone already seen that problem?

using SQL RS with SP1

Lukasz Pawlowski [MSFT]
7/26/2004 2:39:58 PM
What are the execution options for your report? If you've configured the
report execution options to be 'snapshot' then you cannot alter the values
of any parameters that affect the query after the snapshot has been taken.

-Lukasz


--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Renaud Langis
7/27/2004 10:53:44 PM
i am using the web service through ServerXmlHttp. with command =
Render.

It is working well when exporting to pdf.

On Mon, 26 Jul 2004 14:39:58 -0700, "Lukasz Pawlowski [MSFT]"
[quoted text, click to view]
AddThis Social Bookmark Button