Hi friends,
                here is my problem...
I have to extract a list of vendors who are not defined as customers with 'reason'. There are multiple reasons for single vedor and all that needs to be placed in a single row.
say example my report has to look like this

Vend1    vendor name    Reason
09090     abcd vend       Reason 1, Reason 2, Reason 3..

actual out put from database is
vend#      vendorname     cond1   cond2  cond3 cond4
1232     abcd                    Y        N          N        Y
1232     abcd                    N        N          N        Y
1234     xyzc                     Y        y          N        Y
1234     xyzc                     Y        N          N        N

Every reason has a condition. And When I try to write a 'formula' for the reason as

StringVar Reason:= '';
if {Command.DHWKAD} = 'Y' then Reason := Reason + ' ,Weekly Ad';
if {Command.DHMCHG} = 'Y' then Reason := Reason + ' ,Set up';
if {Command.DHSSFL} = 'S' then Reason := Reason + ' ,Scan Charge';
if {Command.CLBBAM} = 'Y' then Reason := Reason + ' ,Bill Back';

The out put i get in crystal reports is

vend#      vendorname     REASON
1232     abcd                  R1, R4
1232     abcd                  R4
1234     xyzc                   R1,R2,R4
1234     xyzc                   R1

I am getting multiple records.... I think i should write a loop for each vendor or something. please help me out....it is an emergency

Thanks in advance

Hi thanks for the replay,
                              Now there are no multiple records. But the report is generated only with the final record of the group inspite of taking the aggregation. I used case statement. I feel that if it has to take the aggregation we have to write a loop again.

Thank you for the suggestion...
                 yaa..by moving into group footer the problem is solved.


Thank you guys....Thanks for your time.