Can I concatenate String input parameter in select expert

[infinitizon]

Ok, maybe the subject does not sound like what I'm seeking but here's the deal:
I use CR10 and I have a couple of number fields. The user can decide to make decisions in searching.

I want to be able to get the user input (string e.g '> 0', '=5', etc) and concactenate it in the field name as the search criteria.
the field is a number field and as such I get error.

Currently, I did this in formular field {@doWhilePrinting}
whileprintingrecords
{purchaseOrderView.Outstanding Quantity} + join({?Outstanding Amount},',').


{?Outstanding Amount} is string such that user can type '> 0', '=5', etc. Can I concatenate the string input like that?

Thanks

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.

 

[lbass]

totext({purchaseOrderView.Outstanding Quantity},0,"")+" "+join({?Outstanding Amount},',')

I added in a space as a separator.

-LB

 

[infinitizon]

lbass thanks, but here's the issue:

{?Outstanding Amount} does not allow multiple strings. It should take only one string from the user in the form "> 0" incase the user wants outstanding amounts greater than 0; "= 5" incase the user wants outstanding amounts equal to 5;"< 10" incase the user wants outstanding amounts less than 10 etc.
The user should have that choice. So, suppose the user wants to display only amounts less greater than 1, he types >1 in the prompt and only results greater than 1 are displayed.

Hope you understand?

 

[lbass]

That is very different from what your first post suggested you were looking for. I think you should change your approach and add two number parameters {?MinAmt} and {?MaxAmt} and then set up your record selection formula like this:

{table.amount} >= {?MinAmt} and
{table.amount} <= {?MaxAmt}

Instruct the user to enter some very large amount if they want no upper limit.

-LB