'Using LIKE (@parameter) in Report Builder Query
I have a report in Report Builder that works fine with a Parameter Field (@job_no). I now wish to add a second parameter encapsulated inside a LIKE argument. Something along the lines of
WHERE (dbo.jm_job.job_no = (@job_no)) AND (dbo.jm_work_order.wo_desc LIKE %'(@wo_desc)'%)
I've tried various styles or argument, but I'm missing something. Thanks
Giles
Solution 1:[1]
To make it work in Oracle databases I found this way useful:
Oracle => LIKE :ParameterName
And define your parameter values as value and wildcards. (Parameter Properties > Parameter Values > Specify Values) ie: Label: ParameterName, Value: ParameterValue%
It worked for me with RRSS 2.0 and Oracle Client & Database 10
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Fernando |