Space between parameters in reporting services

• pwalter83

  SSChampion

  Points: 14575

  More actions

  March 27, 2013 at 10:39 am

  #275679

  Hi,

  I am stuck with an issue which relates to managing space between parameters. I have a multi-value parameter with values like 'KWR TFR' and 'KFT IUT'.

  I know there is data available for these values in the database but because of the space in between the parameter values, it is not detected and the report draws a blank. If there is a value like 'KIETYR', then the data for the same is displayed on the report.

  I have managed to use the split function for the multi-value parameter but dont know what to do with this space in the values.

  Does anyone have any idea ?

  Thanks,

  Paul

• Ness

  SSCarpal Tunnel

  Points: 4282

  More actions

  March 27, 2013 at 11:02 am

  #1601270

  Amend your dataset so that it returns the data without the spaces like ..

  SELECT REPLACE('test space', ' ', '')

  SQL DBA
  Every day is a school day, and don't trust anyone who tells you any different.
  http://sqlblogness.blogspot.co.uk

• pwalter83

  SSChampion

  Points: 14575

  More actions

  March 28, 2013 at 3:07 am

  #1601497

  Ness (3/27/2013)

  ---

  Amend your dataset so that it returns the data without the spaces like ..

  SELECT REPLACE('test space', ' ', '')

  Thanks, but I think you didnt understand my question. I am passing parameter values which have a space in between and because of that the matching data does not get displayed.