I have an SP which accepts a single varchar parameter. The sp works fine when executed from Query Analyser.

I am attempting to run a very simple report from Reporting Services (RS) which executes the sp.

The parameter name used by RS in the URL which generates the report matches that of the sp (but without the '@').

For example, I am trying to pass the parameter 'EUROPE' into @TargetgroupCode, and RS generates the following URL:


However the sp fails to notice the parameter. When I look in profiler, the parameter actually being passed in is :

I tried changing the sp parameter data type to an nvarchar, but this had no effect.

Can anyone tell me what I am doing wrong?