Need help with selection criteria

[staceyn]

Hello,
Using Crystal Xi rel 2 with an informix database.
I have a report request and am not quite sure how to handle the selection criteria.
The user wants to be able to have a parameter that allows a selection against a numerical field.
The required options would be choose all balances, all balances greater than zero or all balances less than zero.
What would be the best way to handle this request?

Thanks in advance for any assistance.

Stacey

 

[Turkbear]

Hi,
As the values and displays for the parameter ( make it a string type)
use
ALL, <0, >0

Then in your record seelction formula test to see which was chosen abd create the formula like:

If [?parameter] = 'ALL' 
then 
True
Else
If [?parameter] = '<0' 
then
{table.numericalfield} < 0
Else
If [?parameter] = '>0' 
then
{table.numericalfield} < 0

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[staceyn]

Thanks Turkbear, that did the trick. I appreciate the assistance..

 

[Turkbear]

Hi,
Glad to help and I hope you caught my typo

If [?parameter] = 'ALL' 
then 
True
Else
If [?parameter] = '<0' 
then
{table.numericalfield} < 0
Else
If [?parameter] = '>0' 
then
{table.numericalfield} < 0 [COLOR=red] should be > 0 [/color]

To Paraphrase:"The Help you get is proportional to the Help you give.."