Parameter problem

[woodyinoz]

Hi all,

I am running CR9 on an SQLBase database

I have set up various parameters a report where by I want the user to be able to enter things such as >18000 and the report will show all record greter then 18000, or they could type in <18000 in the same parameter and get all records less then 18000...... Is this possible? Another problem I have is that the field I am tryin to pass these conditions on is a string field!

I have created a formula which changes this to a number but can't run a parameter on the formula.

If anyone could help in any way I'd be very grateful,

Thanks in advance,

Woody.

 

[lbass]

Try using two parameters: A number parameter {?Amt} and a string parameter {?Sign}. For the {?Sign} parameter, enter defaults like: <, and >.

Your selection formula would then be something like:

if {?Sign} = "<" then
tonumber({table.string}) < {?Amt} else
if {?Sign} = ">" then
tonumber({table.string}) > {?Amt}

-LB