Hi there,
I created a report with a record selection based on parameters. My problem is that report doesn't select any records when I use conditional if.
I want to select records based on officer. To do that I create a parameter officer and want to do record selection basd on officer:
01 Andy
02 Angelo
03 Anne
My record selection is:
{auglsuba.opr_cap} = {?Operational or Capital} and
(if {?Officer} = 01 and {?Operational or Capital} = "O" then
{auglkdes.key_val} in ["1.11.04.06.01.01", "1.11.04.06.01.02"] and
not ({auglmast.lgr_acc} in ["03319", "03318"])) and
(if {?Officer} = 01 and {?Operational or Capital} = "C" then
{auglkdes.key_val} in ["1.11.04.06.02.01", "1.11.04.06.02.02"] and
not ({auglmast.lgr_acc} in ["04834", "04833"]) and
{auglsuba.acc_typ} <> "I") and
{auglkdes.alt_key} = 1
Report works fine if I use a record selection without conditional if:
{auglbals.pst_yer} = {?Posting Year} and
not
{@SuppressZeros} and
{auglsuba.opr_cap} = {?Operational or Capital} and
{auglsuba.acc_typ} <> "I" and
{auglkdes.alt_key} = 1
Any suggestions or pointers appreciated.
-luis
IP Logged
