Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Space between parameters in reporting services

Author  Topic 

lahsiv2004
Starting Member

13 Posts

Posted - 2013-03-27 : 12:49:33
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,
Vishal

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-28 : 05:18:18
you need to encode space characters coming in parameter values before you attach them to URL
see
http://www.w3schools.com/tags/ref_urlencode.asp

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -