Post reply

Space between parameters in reporting services

  • 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

  • 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

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply