SSRS - Report Builder - Wildcard usage in a Filter?
I am trying to use a wildcard in a Filter condition within a SSRS - Report Builder report.
Are wildcards of anytime in fact allowed in this tool? I get errors when I try to use SQL-like wildcards such as '%'. I've also been unable to find any mention of "wildcards" in HELP.
Please help as soon as possible. THANKS!
October 26th, 2007 7:13pm
The report builder is for businerss users where the users may not have the SQL knowledge. Instead set the filter using "Contains". Contains is equivalent to %BLAH%. Not sure how one can achieve "%Blah" or "Blah%" using filters.
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2007 8:41pm
Thank you for your reply. I am already aware of the "Contains" operator and how it is equivalent to %BLAH%. It is the "%Blah" or "Blah%"select that I need to be able to do. Does anyone knowhow to accomplish this?
October 26th, 2007 10:40pm
Is this even possible to have "%blah" or "blah%" filters in report builder?
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2007 12:47am
Have you tried using the wildcard character * as in *blah or blah*?
November 26th, 2007 4:06pm
In the report builder, all the wild cards will be treated as regular characters. So your solution doesn't help.MSFT Team, why isn't there a "Starts With" or "Ends with" filter? Is there any alternative??
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2007 11:35pm
It is * and not %
October 15th, 2010 7:04pm