1

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

giles
  • 823
  • 3
  • 12
  • 25
  • Shouldn't that be `LIKE '%' || @wo_desc || '%'`? –  Nov 01 '11 at 11:51
  • again, trying various connertations, but still failing – giles Nov 01 '11 at 11:55
  • 3
    SQL Server => `LIKE '%' + @wo_desc + '%'` should work – DavidEG Nov 01 '11 at 11:56
  • An answer was provided over here (http://stackoverflow.com/questions/4898358/how-do-i-make-wildcards-work-in-a-like-operator-in-sql-server-reporting-services) I was looking for the same thing. I don't believe this would work with 'multiple' values. –  Sep 11 '13 at 23:20

1 Answers1

0

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

Fernando
  • 1
  • 1