Nov 8, 2010 #1 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
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
Nov 9, 2010 #2 lbass Technical User Feb 9, 2002 32,816 US //{@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 Upvote 0 Downvote
//{@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
Nov 9, 2010 Thread starter #3 jtarry IS-IT--Management Mar 10, 2010 22 GB Thanks, just what I wanted John Upvote 0 Downvote