March 12, 2014 at 7:34 am
Hi All,
It's been a while, not doing as much SQL now sadly however still looking after a reporting server and its woes.
So...I have a report requirement where the user wants to be able to search a call text for a word that will change each time.
For example they want to see if a user has had an issue with a span tag or a search problem, using the words either span or search.
I haev manually pulled a query for now for them but...how would i do this as a parameter within SSRS for the user to have the option of inputting their own word?
Query I have for defining searching is this:
select updatedb.callref, updatedb.updatetxt, updatedb.udsource, opencall.suppgroup
from updatedb
left join opencall
on updatedb.callref=opencall.callref
where udindex = '0'
and suppgroup = 'SUPPORT'
and updatetxt like '%span%'
and opencall.status <> '17'
Thanks for your help in advance!
March 13, 2014 at 10:27 am
Hi Karen,
Create a parameter called @updatetxt.
Then in your query, changed the like statement to this:
and updatetxt like '%' + @updatetxt + '%'
See if that works.
Sarah
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply