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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display of field problem

Status
Not open for further replies.

jtarry

IS-IT--Management
Mar 10, 2010
22
GB
Hi
I have a table:

Part Serialno
AA X01
AA X02
AA X03 etc

want report to show on one line

X01, X02, X03, etc

Thanks
 
//{@reset} for the group header based on a Part group:
whileprintingrecords;
stringvar serno;
if not inrepeatedgroupheader then
serno := "";

//{@accum} for the detail section (suppress this formula):
whileprintingrecords;
stringvar serno := serno + {table.serialno}+", ";

//{@display} for the group footer (Part):
whileprintingrecords;
stringvar serno;
if len(serno) > 2 then
left(serno,len(serno)-2)

Drag the groupname (Part) into the group footer and then suppress the detail section and group header.

-LB
 
Thanks, just what I wanted

John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top