TCL List Grouping (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== TCL List Grouping (AREV Specific) ====
=== At 08 APR 2002 02:32:07AM Troy Griffiths wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Hi,



Another simple question (I am sure) - anyhow:



Using the TCL prompts I am selecting lines, from a table, then listing those lines, however I want to group the lines by a field in the table



Eg LIST DAILY_JOB BY CUST_CD BREAK-ON CUST_CD TOTAL LN_TOT



It is in the above example where I want the have one line per Customer Code. 



What is the "group by" command?



Thanks, again, in advance for any assistance you can offer!



Regards

Troy
</QUOTE>
----

=== At 08 APR 2002 03:57AM Richard Hunt wrote:  ===

<QUOTE>Change the sentence from...

     LIST DAILY_JOB BY CUST_CD BREAK-ON CUST_CD TOTAL LN_TOT

to...

     LIST DAILY_JOB BY CUST_CD BREAK-ON CUST_CD "'V'" TOTAL LN_TOT DET-SUPP



You might want to also add "ID-SUPP".

</QUOTE>

----

=== At 11 APR 2002 02:50AM Troy Griffiths wrote:  ===

<QUOTE>Thanks for that! Brilliant. 



But what does the "V" do?? As all I got in the CUST_CD fields were "V" when this should/ideally be the CUST_CD.



Just for my own knowledge is SUP-DET and SUP-ID supress the Detail and ID fields?



Other than that it is perfect...



Thanks again!



Troy

</QUOTE>

----

=== At 11 APR 2002 11:11AM Don Miller - C3 Inc. wrote:  ===

<QUOTE>But what does the "V" do?? As all I got in the CUST_CD fields were "V" when this should/ideally be the CUST_CD.



The syntax to insert the break-on value is probably incorrect:

BREAK-ON CUST_CD "'V'" ... <= note the double/single quote pairing.  If you're doing this programatically, then it's a little hairier:

CMD:= BREAK-ON CUST_CD "':"'V'":'"' to imbed the proper quotes



Just for my own knowledge is SUP-DET and SUP-ID supress the Detail and ID fields?  DET-SUPP is only useful when you're totalling or using a BREAK-ON with a value item or both.  If you have a whole pile of the same CUST_CD and you only want to see one of them without the details, then DET-SUPP will do that.  If you're totalling some fields(s) then the BREAK-ON CUST-CD "'LV'" TOTAL SOMEFIELDS DET-SUPP will condense the report and omit the extra blank line.  You'll just get the customer code and totals and a grand total at the end.



HTH

Don Miller

C3 Inc.

</QUOTE>

----

=== At 11 APR 2002 07:27PM Troy Griffiths wrote:  ===

<QUOTE>Great. Thank you all.

</QUOTE>


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