flattening data in crystal report 1

[rbarekere]

I have a table which has 4 columns Customer, Partner type, Agent no and employee #.

cust type agent emp
1001 A 01
1001 B a1
1002 A 02
1002 B a2

I have grouped the data based on customer and I would like to flatten the data with 2 columns Agent Emp and I want to have only one row of data.

I tried to create formula for Agent
if {type}="A" then {Agent}
for Emp
if if {type}="B" then {Emp}.

But it didnt work, How I can take a notnull value from a detail and flatten it in groups?

 

[lbass]

Just insert a maximum on each field at the group customer group level, and then suppress the detail section. Drag the groupname into the group footer.

-LB