question

DougWare-3740 avatar image
0 Votes"
DougWare-3740 asked Joyzhao-MSFT edited

ssrs, can parameters be used in a string search

Hello,

I have this substring in SSRS select select statement and where I have "BG". I would like it to be a parameter where users can enter the 2 char code for the select statmement search.

SUBSTRING(pd.od_CON_Abbr, 5, 2) IN ('BG'))

with parameter:

SUBSTRING(pd.od_CON_Abbr, 5, 2) IN ('clientID'))

when I tried to use this in SSRS , I get an error message .

sql-server-transact-sqlsql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Could you share the complete query statement and the error message when you create the dataset?

0 Votes 0 ·

0 Answers