Sort with DET-SUPP and display columns (AREV Specific)
At 15 MAY 2001 09:53:13PM Jeff Ritchie wrote:
Is it possible to do something like
Sort Sales by Cust_id Break-On Cust_Id Cust_name Total Sales_Amt DET-SUPP
and get the Cust_name to display in the total line that is produced for each customer.
At 16 MAY 2001 03:54AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Use "'V'" after the BREAK-ON COLUMNNAME.
World Leaders in all things RevSoft
At 16 MAY 2001 12:09PM Don Miller - C3 Inc. wrote:
Jeff:
Your Original:
Sort Sales by Cust_id Break-On Cust_Id Cust_name Total Sales_Amt DET-SUPP
Should be:
Sort Sales by Cust_id Break-On Cust_name "'LUUV'" Cust_name Total Sales_Amt DET-SUPP
The LUUV will suppress a double-line feed and Over/Underline the Totalling field. This will only work properly if your customer names are unique within the Cust_id sorted universe. If you just put a "'V'" option, only the Cust_name info will appear
HTH
Don Miller
C3 Inc.
At 16 MAY 2001 06:35PM Jeff Ritchie wrote:
Thanks Guys,
Will check that out today. Am trying to avoid writing a program for what should be a simple sub totaling report.