SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Space between parameters in reporting services
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lahsiv2004
Starting Member

9 Posts

Posted - 03/27/2013 :  12:49:33  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 03/28/2013 :  05:18:18  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.01 seconds. Powered By: Snitz Forums 2000