214
edits
Changes
no edit summary
'''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.
<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'''isce'''llaneous without having to type %isc% as you normally would with the LIKE ??? syntax.
[[Category:Reports]][[Category:FAQ]]
''A: You need to put the following code in the Criteria box of the Report Builder.
<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'''isce'''llaneous without having to type %isc% as you normally would with the LIKE ??? syntax.
[[Category:Reports]][[Category:FAQ]]