How do I make my report accept user prompts with built-in wild cards?
From SmartWiki
Revision as of 09:56, 30 April 2013 by Arthur Lathrop (talk | contribs)
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.