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
ThanksWhat 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.
"Renaud Langis" <rlangis@.sympatico.ca> wrote in message
news:l273g0lrcb8ao5ibu0du8rcvnhlbfuvi5v@.4ax.com...
> 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
> Thanks|||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]"
<lukaszp@.online.microsoft.com> wrote:
>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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment