Error! Must declare the varaible

Hi
Can someone help me with the following problem? I have a report that needs
two parameters at runtime. If I execute this report on the same server as RS
with a data source that is connected to a database on the same server as the
RS server. Then the report execute without any problems.
The setup is as follow:
SQL 2000 running on Windows 2003 Server, with XP Professional
workstations connecting to the RS.There is also three other SQL 2000 servers
running on Windows 2003 Server.
The problem occurs when the Data Source points to a database on a separate
server than the RS server. In this scenario the report executes with an
Error.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'SRCC'. (rsErrorExecutingCommand) Get
Online Help
Must declare the variable '@.PCode'.
If the report contains no parameters, it executes without any error. Only if
it contains parameters does it execute with an error. If someone can tell me
why this is happening I will really appreciate it.
Thanx
MVAHi,
Have you done anything like this in thr Data tab.
set @.ecode = 1002
select * from employee where empno = @.ecode
Then you will get the error. If you can share the full query with dummy
values that's well and good. If you get "must declare @.pcode" then it must be
something to do with the query and I hope you didnt give anywhere in the
report "@.pcode". In that case you may get this error.
Amarnath.
"MVA" wrote:
> Hi
> Can someone help me with the following problem? I have a report that needs
> two parameters at runtime. If I execute this report on the same server as RS
> with a data source that is connected to a database on the same server as the
> RS server. Then the report execute without any problems.
> The setup is as follow:
> SQL 2000 running on Windows 2003 Server, with XP Professional
> workstations connecting to the RS.There is also three other SQL 2000 servers
> running on Windows 2003 Server.
> The problem occurs when the Data Source points to a database on a separate
> server than the RS server. In this scenario the report executes with an
> Error.
>
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'SRCC'. (rsErrorExecutingCommand) Get
> Online Help
> Must declare the variable '@.PCode'.
>
> If the report contains no parameters, it executes without any error. Only if
> it contains parameters does it execute with an error. If someone can tell me
> why this is happening I will really appreciate it.
>
> Thanx
> MVA
>
>