INV000000601	DP00000008	KARINE	LEE HWEE YAW	X0000009
	DP00000008			X0000010
	DP00000008			X0000010
	DP00000008			X0000010
	DP00000008			X0000009
	DP00000008			X0000009
	DP00000008			X0000043
INV000000602	Cheque			X0000009
	Cheque			X0000010
	Cheque			X0000010
	Cheque			X0000010
	Cheque			X0000009
	Cheque			X0000009
	Cheque			X0000043
INV000000603	Cash			X0000009
	Cash			X0000010
	Cash			X0000010
	Cash			X0000010
	Cash			X0000009
	Cash			X0000009
	Cash			X0000043
INV000000604	Cheque			X0000009
	Cheque			X0000010
	Cheque			X0000010
	Cheque			X0000010
	Cheque			X0000009
	Cheque			X0000009

Hi,

based on above captures, how do i trim away repeated data in the columns?

if i move everything to group. it will show only

INV000000601

DP00000008

KARINE

LEE HWEE YAW

X0000009

but my others details will truncated.

I write suppress formating formulas.
You can use IF to compare your values with global vars, previous(), isnull({...}) and so on...
for instance:

if Date({DM_ACTIVITY.time_from}) = Date(Previous ({DM_ACTIVITY.time_from}))
 and {DM_ACTIVITY.activity_code} = Previous ({DM_ACTIVITY.activity_code}) then
    true
else
    false;



Edited by __Yuri__ - 24 Jun 2007 at 2:46am