Multiple records - single row

[veronic]

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;

if not(totext({@ExitDate}) in data)then
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 example: 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"....

 

[pgtek]

hi
click in the format section detail
and select format multiple collum and row

cheers

pg


pgtek

 

[veronic]

still does not work..??

 

[pgtek]

hi
check ken website

http://www.kenhamady.com/formula.html

cheers
pg

pgtek

 

[lbass]

Try changing your detail formula to:

whileprintingrecords;
Global stringvar data;

if instr(data, totext({@ExitDate},"M/d/yy")) = 0 then
data := data + totext({@ExitDate},"M/d/yy") + " " else
data := data;

-LB

 

[veronic]

doesn't work. The same result...

 

[GMcNamara]

I created a sample report just as you described. I literally cut and pasted your formulas into my report. It is working fine for me. Are you grouping on the Provider #? This may affect your result somehow.

 

[GMcNamara]

Also, are you pulling data from multiple tables?

 

[veronic]

I am pulling data from one view. And I am grouping by Proj #