Parameter for a word search in SSRS

  • 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!

  • 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