Parameter using * as a character

[ClowneUser]

Hi,
i have a report that pulls customer order details that need to be delivered by a specific date and this works well. what I have been asked to do is to add another parameter that breaks it down by part number, the issue is that the part numbers all begin with either F* or R* ( this is a string )

I created a selection formula like this:
{CUSTOMER_ORDER_LINE\.CATALOG_DESC} like {?Part} + "*"

But it still brings back all orders with parts beginning with either R or F whether there is a * in the name or not obviously it is treating the * in the part name as a wildcard.

My question is is it possible to achieve what I need to?

Regards,
Mick.

 

[pmax9999]

I think that by using the 'like' function CR will be treating the * as a wildcard. Try amending your selection formula to:

{CUSTOMER_ORDER_LINE\.CATALOG_DESC} startswith ({?Part} + "*")

Does this help?

Cheers
Pete

 

[ClowneUser]

Pete,
Thanks for your reply, that looks like its done the trick, I'd never heard of the 'startswith' function.

Thanks again, much appreciated.

Mick.