Suppressing data

[lilal111]

I am currently using a report with a sub report. I am trying to suppress the data in the sub report where it already exists in the main report between the two fields and only show the fields that don't match. Pardon the crude example below, but in essence it is what I am trying to accomplish.

For instance

main report field : a
b
c

subreport a
b
c
d

I would only like to display the d in the sub report where the other ones match.

thanks.

 

[lbass]

In the main report, add a formula like this to the detail section and suppress it if you like:

whileprintingrecords;
shared stringvar array x;
numbervar i := i + 1;
numbervar j := count({table.field});
if i <= j then (
redim preserve x[j];
x := {table.field}
);

In the subreport->section expert->details->suppress->x+2 enter:
whileprintingrecords;
shared stringvar array x;
numbervar i;
numbervar j := count({table.field});
booleanvar flag := false;
for i := 1 to j do(
redim preserve x[j];
if {table.field} = x then
flag := true
);
flag

-LB

 

[lilal111]

Thank you very much, this worked great....You made my day!!