Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help in Group by. 1

Status
Not open for further replies.

saran26

Programmer
May 20, 2008
173
US
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


 
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
 
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
 
Hi,

Thanks for the info.

I didn't read your reply fully.

Now I am seeing every thing in a lin

Thanks
Saran
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top