(IF "DGA" in {OPPOR.STE_1} then {OPPOR.ENDDAT_1}) +
(IF "DGA" in {OPPOR.STE_2} then {OPPOR.ENDDAT_2}) +
(IF "DGA" in {OPPOR.STE_3} then {OPPOR.ENDDAT_3}) +
(if "DGA" in {OPPOR.STE_4} then {OPPOR.ENDDAT_4}) +
(IF "DGA" in {OPPOR.STE_5} then {OPPOR.ENDDAT_5}) +
(IF "DGA" in {OPPOR.STE_6} then {OPPOR.ENDDAT_6}) +
(IF "DGA" in {OPPOR.STE_7} then {OPPOR.ENDDAT_7}) +
(IF "DGA" in {OPPOR.STE_8} then {OPPOR.ENDDAT_8}) +
(IF "DGA" in {OPPOR.STE_9} then {OPPOR.ENDDAT_9}) +
(IF "DGA" in {OPPOR.STE_10} then {OPPOR.ENDDAT_10}) +
(IF "DGA" in {OPPOR.STE_11} then {OPPOR.ENDDAT_11}) +
(IF "DGA" in {OPPOR.STE_12} then {OPPOR.ENDDAT_12}) +
(IF "DGA" in {OPPOR.STE_13} then {OPPOR.ENDDAT_13}) +
(IF "DGA" in {OPPOR.STE_14} then {OPPOR.ENDDAT_14})
I am trying to accomplish placing the date of the completion of a project in to the report. "DGA" is the code that signifies the project is complete. If the code in OPPOR.STE_0 is "DGA" then I want the corresponding DATE to appear in the report. Right now, it sends me an error that "A number is expected here" and it highlights the first row.
Any suggestions?
Thanks-
Minco
IP Logged
