SELECTION CRITERIA WITH PARAMETER FIELDS 1

[Ann28]

Hello Everyone!


I have 3 input parameters on the report TYPE, DATE FROM & DATE TO on the report

On the Select Exert the formula is:

 if {?CHECK TYPE } = "B" then
{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO}
else
{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO} and
{ILGW_VACATION.CHECK_STATUS} = {?CHECK TYPE }

The user can enter P or V for the TYPE.
The TYPE has values: V, P & P1.

How do I set-up the formula/criteria where the user enters P and the P1 records will be selected as well?

The CR version is 9.2

THANKS A LOT FOR YOUR HELP!!!!

 

[Ann28]

GOT IT!

if {?CHECK TYPE } = "B" then
{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO}
else
if {?CHECK TYPE } = "P" then
{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO} and
{ILGW_VACATION.CHECK_STATUS} = {?CHECK TYPE } or {ILGW_VACATION.CHECK_STATUS} = "P2"
else
if {?CHECK TYPE } = "V" then
{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO} and
{ILGW_VACATION.CHECK_STATUS} = "V"

 

[Ann28]

This formula does seem to be accurate
ANY CORRECTIONS ARE REALLY APPRECIATED!!!

If {?CHECK TYPE } = "B" then
{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO}
else
if {?CHECK TYPE } = "P" then
{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO} and
{ILGW_VACATION.CHECK_STATUS} = {?CHECK TYPE } OR
({ILGW_VACATION.CHECK_STATUS} = "P2" AND {ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO} )
else
if {?CHECK TYPE } = "V" then
{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO} and
{ILGW_VACATION.CHECK_STATUS} = "V

 

[lbass]

I guess you meant that it did NOT work. Try:

{ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO} and
(
If {?CHECK TYPE } = "V" then
{ILGW_VACATION.CHECK_STATUS} = {?CHECK TYPE} else
if {?CHECK TYPE } = "P" then
{ILGW_VACATION.CHECK_STATUS} in ["P","P2"] else
if {?CHECK TYPE} = "B" then true
)

This assumes that "B" is the status where you want all check types to appear.

-LB

 

[Ann28]

looks much better I'll use this formula
THANK YOU