Difference between revisions of "How do I make my report accept user prompts with built-in wild cards?"
From SmartWiki
Line 5: | Line 5: | ||
<pre>LIKE concat('%',???,'%')</pre> | <pre>LIKE concat('%',???,'%')</pre> | ||
− | Putting this in the criteria box will allow the user to enter '''isc''' in the report prompt, and get results like d'''isc'''ount or m''' | + | Putting this in the criteria box will allow the user to enter '''isc''' in the report prompt, and get results like d'''isc'''ount or m'''isc'''ellaneous without having to type %isc% as you normally would with the LIKE ??? syntax. |
+ | |||
+ | ==See Also== | ||
+ | * [[Prompting for a Criteria using a Wildcard]] | ||
[[Category:Reports]][[Category:FAQ]] | [[Category:Reports]][[Category:FAQ]] |
Latest revision as of 09:56, 30 April 2013
Q: How do I make my report accept user prompts with built-in wild cards?
A: You need to put the following code in the Criteria box of the Report Builder.
LIKE concat('%',???,'%')
Putting this in the criteria box will allow the user to enter isc in the report prompt, and get results like discount or miscellaneous without having to type %isc% as you normally would with the LIKE ??? syntax.