Baggers2003
Programmer
HI all,
I am pretty new to this, so apologies if this is a silly question, but I Have entered the following into the Report - Edit Selection Formula - Group formula window:
NOT IsNull(Sum ({D020FIG_LY.STERL01}, {CTPATMS.PTCATG}))OR
NOT IsNull(Sum ({D020FIG_TM.STERL01}, {CTPATMS.PTCATG})) OR
NOT IsNull(Sum ({D020FIG_TY.STERL01}, {CTPATMS.PTCATG})) OR
NOT IsNull(Sum ({D020FIG_LM_1.STERL01}, {CTPATMS.PTCATG}))
However, although the equation was OK, it produced a result I did not want, but when I went back to change it - it was gone! Also, if I right click on "Group #2 Name" in the design view (this being the group that the above sum() refers to) and choose the Select expert for any of the fields in the formula above - there is nothing there either.
How do I edit Group selection formula? Surely there's a way? Does anyone know?
Cheers,
Steve
I am pretty new to this, so apologies if this is a silly question, but I Have entered the following into the Report - Edit Selection Formula - Group formula window:
NOT IsNull(Sum ({D020FIG_LY.STERL01}, {CTPATMS.PTCATG}))OR
NOT IsNull(Sum ({D020FIG_TM.STERL01}, {CTPATMS.PTCATG})) OR
NOT IsNull(Sum ({D020FIG_TY.STERL01}, {CTPATMS.PTCATG})) OR
NOT IsNull(Sum ({D020FIG_LM_1.STERL01}, {CTPATMS.PTCATG}))
However, although the equation was OK, it produced a result I did not want, but when I went back to change it - it was gone! Also, if I right click on "Group #2 Name" in the design view (this being the group that the above sum() refers to) and choose the Select expert for any of the fields in the formula above - there is nothing there either.
How do I edit Group selection formula? Surely there's a way? Does anyone know?
Cheers,
Steve