Need help in Group by. 1

[saran26]

Hi All

I have the following fields in my table

id, name and assigned to.

The table has the following values

1 saran gopi,ram and suman

I want to do group by on id and display the results, when i display all the above in the group section it displays like this

1 saran suman

it displays only the last value

if i move the assigned to field to the details tab then it displays

1 saran

gopi
ram
suman

but there is a gap in the display because the multiple values are displayed in the details section .

How to avoid this.

Please help me out.

Thanks
Saran

 

[lbass]

Collect the values in a variable. Create these formulas:

//{@reset} to be placed in the ID group header:
whileprintingrecords;
stringvar assigned;
if not inrepeatedgroupheader then
assigned := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar assigned := assigned + {table.assigned_to}+", ";

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar assigned;
if len(assigned) > 2 then
left(assigned,len(assigned)-2);

Suppress the group header and detail section, and drag the first two detail fields into the group footer next to {@display}.

-LB

 

[saran26]

Hi ,

It worked . But there is a gap between the items in the group and the assigned to which is displayed in the footer.

Can we place the display field it on the group header itself.?

Please let me know.

Thanks
Saran

 

[saran26]

Hi,

Thanks for the info.

I didn't read your reply fully.

Now I am seeing every thing in a lin

Thanks
Saran