Need help with parameters

[staceyn]

Hello,
I am using Crystal XI rel 2 with an informix database.
I have had a request to create a report with multiple parameter selections.
The request is:
to choose vendor id (string field)or have the option to choose all
to choose PO date (date field) or have the option to choose all
to choose the balance (numeric field) amount of < 0, > 0 or all.

All of the information can be found in the PO table.
There are fields for po_vendor, po_date and po_cost as well as the addtional required fields for the report.

I'm not quite sure how to be able to get an 'ALL' option for these fields, how to have the 'ALL' option as an option in the parameter list and to have record selections based on these values. I might also need some addtional help for how to select based on a parameter a balance of < 0, > 0 or all.


Any advice would be greatly appreciated.

Thanks,
Stacey

 

[pomster]

Stacey,

Try this:

(if {?vendor id} <> "All"
then
{table.vendor id} = ({?vendor id})
else
if {?vendor id} = "All" then true)

regards,


David

CRXIR2 with CRXIR2 server and SQL 2005