Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Parameter for a word search in SSRS Expand / Collapse
Posted Wednesday, March 12, 2014 7:34 AM


Group: General Forum Members
Last Login: Yesterday @ 1:48 AM
Points: 110, Visits: 525
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 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!
Post #1550233
Posted Thursday, March 13, 2014 10:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:57 AM
Points: 93, Visits: 512
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.

Post #1550813
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse