Static Parameter with wildcard

building reports crystal reports
1

I am creating a report where I need to allow the user to enter part of the business name or the whole name, how can add a wildcard to the record selection formula editor. I have tried like * but I got error messages or the parameter did not work. This is my formula
TRIM({table.fieldname}) = {?Business Name}
AND
{table.fieldname} = 1110.00 and
//review approved
{table.fieldname} = 1 and
//permit issued
date({table.fieldname}) <> DateTime (0, 0, 0, 0, 0, 0)
Thanks,
Angie

rio826 (BOB member since 2009-07-20)

2

try creating a static parameter with out any data indicate then place the parameter you created in the report. This allow the user to Enter any data they want…I hope this will help

nahtanoj :philippines: (BOB member since 2009-07-08)