Pass through Parameter and Like in Select

[bsibengal]

Crystal Reports 9. I am passing through a Parameter to a subreport. I expect the parameter to be given a value by the user similar to"FY 07" for fiscal year.
I then need to select a record based on a text description field containing the parameter value. For example, I want records described as "FY 07 - Revised Budget".

So, I end up with the following, which doesn't work.

{Budget.Description} like {?Pm-FiscalYear}

How do I get the wildcards in there? And thank you in advance for your advice. You guys rock!

 

[lbass]

Try:

{Budget.Description} like "*"+{?Pm-FiscalYear}+"*"

-LB

 

[bsibengal]

That solution did not work, but I did have success taking your suggestion theory and creating an interim formula parameter that is set to equal the passthrough parameter.

I added the following line to the select:
{BUDGET.DESCRIPTION} like "*"+{@FiscalYear}+"*"

And it worked. thanks!