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:
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] [3eyes] [3eyes]](/data/assets/smilies/3eyes.gif)
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] [3eyes] [3eyes]](/data/assets/smilies/3eyes.gif)