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
left join opencall
where udindex = '0'
and suppgroup = 'SUPPORT'
and updatetxt like '%span%'
and opencall.status <> '17'
Thanks for your help in advance!