CODEWITHSUNDEEP
sqlsql-server-2008reporting-services
Bonzay
Bonzay

Reputation: 750

pass string in SSRS parameter, without double quotes

I am trying to allow the user to pass a text parameter in an SSRS report like this:

'value1','value2','value3','value4'

The idea is to use it in my dataset query in a where in clause.

I think SSRS passes the above parameter to the query like this:

"'value1','value2','value3','value4'" which messes up my query.

How can this work?

Upvotes: 0

Views: 1168

Answers (1)

AnkUser
AnkUser

Reputation: 5531

Yes you can definitely do that, You need to create parameter as below enter image description here

Then If you are using sql statement you can use in your sql statement as

select * from customer where customerid=@ReportParameter1

Here are 2 links for Ref

https://reportsyouneed.com/ssrs-tip-put-parameters-in-your-query-not-your-filter/

https://learn.microsoft.com/en-us/sql/reporting-services/tutorial-add-a-parameter-to-your-report-report-builder?view=sql-server-2017#Query

Upvotes: 2

Related Questions