Formula issue

[2328]

Hi I need to display multiple rows into Single row, May be my question is wrong
Here is the data
Group Name,
Fields
-----------------------------
Lakeridge
EU:CE A
EU:CE A
EU:CE-AM B
EU:CE-SO c
--------------------------------------------------


I need to see output in this manner

Lakeridge A B C
A

I wrote 3 different formula like IF X=EU:CE Then A
and kept it in footer but no use,
I may use CR 11 or 10

Any suggestions apprciated

 

[dgillz]

Please explain the tables in your report and the way they are linked.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[2328]

Its just one table
Lakeridge as col 1
EU:CE As Col 2
A,B,C as Col 3

col 3 may have multiple values for colu 2

 

[lbass]

You could insert a group on col1, and then create these formulas:

//{@reset} to be placed in the group header:
whileprintingrecords;
stringvar xA := "";
stringvar xB := "";
stringvar xC := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar xA;
stringvar xB;
stringvar xC;
if {table.col2} = "EU:CE" then
xA := xA + "A" + chr(13);
if {table.col2} = "EU:CE-AM" then
xB := xB + "B" + chr(13);
if {table.col2} = "EU:CE-SO" then
xC := xC + "C" + chr(13);

//{@displayA} to be placed in the group footer:
whileprintingrecords;
stringvar xA;

//{@displayB} to be placed in the group footer:
whileprintingrecords;
stringvar xB;

//{@displayC} to be placed in the group footer:
whileprintingrecords;
stringvar xC;

Format each of the display formulas to "can grow". Drag the group name into the group footer and then suppress the GH and detail section.

-LB

 

[2328]

Thanks Lbass,
I really apprecaite your very very active and helping nature.
I will try that.
Once again thanks

 

[2328]

It worked, great thanks