Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SELECTION CRITERIA WITH PARAMETER FIELDS 1

Status
Not open for further replies.

Ann28

MIS
Apr 2, 2004
97
US
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:

Code:
 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!!!! [3eyes]
 
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"

 
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
 
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
 
looks much better I'll use this formula
THANK YOU
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top