Multiple records into a single row???

[vshapiro]

I need to combine multiple records into a single row in the report.
For example:
I want it to show like:
Project# Provider# Date1, Date2, Date3
1111 2222 1/1/01 2/2/02 1/2/02

This is actually three different records (same project#,
same Provider but each date - different record.
This is what I am doing:

Group by the Project #.

In the Project# group header place:

whileprintingrecords;
Global stringvar data := "";


In the Details Section place:

whileprintingrecords;
Global stringvar data;
data:= data + totext({@ExitDate})

In the Project# group footer place:
whileprintingrecords;
Global stringvar data;
data

Everything works OK but....
my field 'data' come on the reports couple of dates together - for exmple: 09/02/200209/02/200209/02/2002
Yes, I have couple of records which have same project#(which I grouped) and same date (I cannot group it).
What should I do to look my field "NORMAL"....

Thank you

 

[synapsevampire]

In the Details Section place:

whileprintingrecords;
Global stringvar data;
if not(totext({@ExitDate}) in data)then
data:= data + totext({@ExitDate});

This should only place unique values in the variable data.

-k

 

[vshapiro]

Thank you very much

I'll try!!