[[https://www.revelation.com/|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]]


==== Sort with DET-SUPP and display columns (AREV Specific) ====
=== At 15 MAY 2001 09:53:13PM Jeff Ritchie wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
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.
</QUOTE>
----

=== 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:  ===

<QUOTE>Use "'V'" after the BREAK-ON COLUMNNAME.



[url=http://www.sprezzatura.com" ]The Sprezzatura Group[/url] 

[i]World Leaders in all things RevSoft[/i] 

[img]http://www.sprezzatura.com/zz.gif[/img] 

 

 

</QUOTE>

----

=== At 16 MAY 2001 12:09PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>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.



</QUOTE>

----

=== At 16 MAY 2001 06:35PM Jeff Ritchie wrote:  ===

<QUOTE>Thanks Guys,



Will check that out today. Am trying to avoid writing a program for what should be a simple sub totaling report.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=80BABB5CB8F51A7385256A4E000A5DD1|View this thread on the  forum...]]