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
Author
Message
Posted Wednesday, March 12, 2014 7:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, October 17, 2014 8:14 AM
Points: 90, Visits: 452
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!
Post #1550233
Posted Thursday, March 13, 2014 10:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 7:50 AM
Points: 42, Visits: 305
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
Post #1550813
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse