this is a tough one.
What you need to do is to turn multiple rows into 1.
What I would to is use shared variables and for each 'final' row I would fill in the correct variable, then in the group footer (which would be for the 'final' row) display the values.
something like:
shared stringvar a;
shared stringvar b;
shared stringvar c;
shared stringvar d;
shared stringvar e;
if ({table.field}="bag" then
a:= {table.field}
else
a: = "n/a";
repeat for other values.
in group footer you would have several formulas, 1 per variable that look like:
shared stringvar a;
a
suppress the detail section, and hopefully all works as desired.
HTH
IP Logged
