Sort with DET-SUPP and display columns (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 15 MAY 2001 09:53:13PM Jeff Ritchie wrote:

AREV Specific

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.

The Sprezzatura Group

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.

View this thread on the forum...