How to make a loop in a report?
Hi,
I am modifying a report, and I am not able to do what I want. In the master data there are several columns. One of them is TYPE, which can be 'A','R' or 'N'. Another one is NUMF and is an integer. What I want to do, is to get in the master footer the sum of all the NUMF rows, but only if TYPE is different of 'N'.
I don't know if this is even possible. My idea was to make a loop and for each row check the value of TYPE, but I don't know how to do this. I tried multiple possibilities ["TYPE"][1], ["TYPE"[1]], ... but nothing seems to work.
I would appreciate any help.
Thanks in advance, Salaye
I am modifying a report, and I am not able to do what I want. In the master data there are several columns. One of them is TYPE, which can be 'A','R' or 'N'. Another one is NUMF and is an integer. What I want to do, is to get in the master footer the sum of all the NUMF rows, but only if TYPE is different of 'N'.
I don't know if this is even possible. My idea was to make a loop and for each row check the value of TYPE, but I don't know how to do this. I tried multiple possibilities ["TYPE"][1], ["TYPE"[1]], ... but nothing seems to work.
I would appreciate any help.
Thanks in advance, Salaye