Question about parameters

• jane.frasier

  SSC Enthusiast

  Points: 191

  More actions

  October 18, 2012 at 6:26 pm

  #264354

  I inherited a database and it has a field named Location and it contains multiple entries, like record one might be AR, BL, LK and record 2 might be LK,SL,WR and record 3 might be LK.

  I would like to ask the user which location do they want and if they type AR they would get record 1 and if they type LK they would get all 3. In Access this is possible using

  WHERE (((TSubs.Location) Like "*" & [Enter location] & "*")

  I don't see how in SSRS I can do this.

  Thanks.

• H4K

  Hall of Fame

  Points: 3374

  More actions

  October 18, 2012 at 11:48 pm

  #1550723

  you can a where clause in the sql query like:

  where location like '%LK%'

  BI Developer
  SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
  Please visit... ApplyBI