SSRS Parameter

Question

Hi,

I just started to use migrating to SSRS Version 15.0.1102.675 from Version 9.00.3073.00. In 9.00, I can just declare the parameter for the report and use @selectedYear in the sql statement but in the new version I keep getting an error "Query execution failed for dataset 'DataSet1'. Must declare the scalar variable @selectedYear".

I found if I use "?" and set up the parameter name as "?" and parameter value as @selectedYear in the Dataset Properties, the query works.

I would prefer to use the parameter in the sql query instead of using a "?". How can I do that? I've searched all over but can only find examples of using the parameter in the sql query instead of using "?"

Thank you

Answer 1

Regarding parameter handling nothing has changed between the version and which parameter type to use depends on the used data provider, not on SSRS version.

Have you changed the data provider? Which one are you using?

Answer 2

Hi @Long ,

I agree with Olaf's opinion, the SSRS version should not affect the the parameter.

Could you please share the simple query with us so that we could do more test.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.