Newbie needs help with formula

[Lilliabeth]

Only very seldom am I asked to work with Crystal. I'd really appreciate some help with this formula.

({po_vch.voucher} in {?StartingVoucher} to {?EndingVoucher});
({po_vch.po_num} in {?StartingPO} to {?EndingPO});
({po_vch.rcvd_date} in {?StartingRecdDate} to {?EndingRecdDate})

The above does not work. I've tried replacing the ";" with "and" and also tried "or". I cannot get any of these to work. I want the option of either entering one or all three variables.

 

[lbass]

What version of CR are you using? What are the datatypes for the fields you are using in the formula?

-LB

 

[MisterMo]

Hi

If you set the parameters as ranges you will only need one parameter for each field

eg
({po_vch.voucher} in {?StartingVoucher} to {?EndingVoucher});
can be changed to
create new parameter
?Voucher with the following options Numeric and Range then your selection formula would look like

{po_vch.voucher} = {?Voucher}

do this for the other two just remember to set the last one to a date field.

no ';' required


-Mo

 

[dgillz]

You should use 'and' not ';'

What is the purpose of this formula? Is it to limit the recordset of the report? If so please confirm that you are not creating a new formula field but are entering the formula under report, edit selection formula, record or under report, selection formulas, record (this varies depending upon your version of Crystal, hence the need to always include this info as LB mentioned).





Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz