Report Parameters - Special Characters (Asterisk)
Hi All, I have a report parameter named "Comment". The datatype of the report parameter is string. So, If I enter "*" then I should be able to pull all matching records with "*". As "*" is being used as a wild card character, i a m not able to achieve this. I have tried this. ="**[*]**" Any help is apreciated. Thanks, PrawinPrawin
July 29th, 2011 10:05am

Hi Prawin, You can try this:- DECLARE @ST VARCHAR(10) SET @ST = '*' CREATE TABLE #TEMP ( ST VARCHAR(50) ) INSERT INTO #TEMP VALUES ( 'This is great work' ) INSERT INTO #TEMP VALUES ( 'This shou*ld be great work' ) INSERT INTO #TEMP VALUES ( 'This is* adorable' ) INSERT INTO #TEMP VALUES ( 'This shou%ld be great work' ) INSERT INTO #TEMP VALUES ( 'This is great %work' ) SELECT ST FROM #TEMP WHERE ST LIKE '%[' + RTRIM(LTRIM(@ST)) + ']%' DROP TABLE #TEMP I have created sample example "Parameter with Special Characters.rdl", you need to change the DataSource as per your req. https://skydrive.live.com/#cid=15E0E13BD0545504&id=15E0E13BD0545504%21137 Please let us know your feedback when you get a chance. Thanks KumarPlease do let us know your feedback. Thank You - KG, MCTS
Free Windows Admin Tool Kit Click here and download it now
July 29th, 2011 11:01am

Hi Kumar, Thanks for your response. But, we are talking about the Tablix filters. Actually.. As per our requirement, we should not hit database when the user clicks on "View Report" after providing the input values. I hope your approach will hit database for each search. Please correct me if i am not correct. Thanks, PrawinPrawin
July 29th, 2011 11:41am

Hi Prawin, I'm not sure why is your req. is like this but anyways, here is the updated version:- https://skydrive.live.com/P.mvc#!/?cid=15e0e13bd0545504&sc=documents&uc=1&id=15E0E13BD0545504%21137 ""Parameter with Special Characters.rdl" Still I'm unable to search using * (asterisk), my guess is asterisk is been used by "Characters in the pattern", otherwise I'm able to use % as expected, please follow below link for LIKE operator functionality:- http://msdn.microsoft.com/en-us/library/swf8kaxw(VS.71).aspx Please let us know if you have any further issues with this. Thanks KumarPlease do let us know your feedback. Thank You - KG, MCTS
Free Windows Admin Tool Kit Click here and download it now
July 29th, 2011 2:12pm

Hi Kumar, Let me give you more details. As My database/table size is huge, only on the initial load, I want to go to database and pull all the records and for the next time on clikco f the "View Report" button, Instead of going back to database, I just want to filter the data that has already been pulled. So, I am using Report Parameters/ Filters. (Please note that the query of my database dont have any parameters...) So, Iam facing problems when the data has asterisk in them as "*" is used as a wild card character. So, My problem is when user search with a "*" i need to pull the matching records. Please let me know if my explanation is not clear. I will try to provide the screenshot of how i have configured the report paramters/filters. Thanks, Prawin Prawin
July 29th, 2011 2:22pm

Hi Prawin, Got it. Did you try to execute my example it is working perfectly with "%" BUT NOT WITH "*", based on this link:- http://msdn.microsoft.com/en-us/library/swf8kaxw(VS.71).aspx Also if you trying huge pull of data, report from the SSAS (ROALP or MOLAP) using MDX queries will be much more effitive in terms of speeding the rending of the report. Thanks KumarPlease do let us know your feedback. Thank You - KG, MCTS
Free Windows Admin Tool Kit Click here and download it now
July 29th, 2011 2:28pm

Hi Kumar, We are already using the Caching technique as the data gets updated in the table only once a day! But, I wanted to know the escape sequence in SSRS. Kindly help me. Thanks, PrawinPrawin
July 29th, 2011 2:37pm

Hi Prawin, please refer to the simlar thread, and then check if it works for you. Is there an escape character in SSRS scripting: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/28a78133-fe70-4e7a-8a6c-c51f4112b42b/ If you have any question, please feel free to ask. Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2011 11:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics