[[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]]


==== Count and SLIST/RList (OpenInsight Specific) ====
=== At 20 DEC 2001 12:27:15PM a becker wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
Is there anyway that I can produce a report using SLIST that will allow me to count the records in a break-on WITHOUT having the count displayed in the report.



Any time I try to do a count, experimenting with SYSTEM EDITOR and using RLIST it displays the count for each record.



Example : RUN RLIST "LIST table BREAK-ON field1 TOTAL COUNT field2



this shows the count column on the report.  I tried to use justlen 0 on count, which does not display it provided you don't TOTAL.  Once you use TOTAL, count displays no matter what justlen reads.



Any ideas?



Thanks



Andy Becker

Illinois State Lottery
</QUOTE>
----

=== At 20 DEC 2001 01:53PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]  wrote:  ===

<QUOTE>Well you could use the new break-on options we added into SLIST for just this purpose - to quote the new on-line docs (soon to be revealed in the next SENL)



"There are two new formatting options for Break-On, both of which are incorporated in the example below. 





'C'  substitutes a count of the total number of rows in the current break clause  

'R' tells the break clause to present running totals or averages rather than resetting the values at each break "



[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 20 DEC 2001 02:01PM a becker wrote:  ===

<QUOTE>Thanks, I'll give it a try.

</QUOTE>

----

=== At 20 DEC 2001 02:42PM a becker wrote:  ===

<QUOTE>What am I doing wrong?



I tried the following in my SLIST statement



    BREAK-ON LOCATION_NAME 'C' BREAK-ON ITEM_NUMBER 'C'

Report would not run



Then I tried:

    BREAK-ON LOCATION_NAME C BREAK-ON ITEM_NUMBER C

Didn't run



Then tried

    BREAK-ON LOCATION_NAME 'C LOCATION_NAME' BREAK-ON ITEM_NUMBER 'C ITEM NUMBER'

Didn't run



What am I doing wrong or do we need to update our SLIST97?



Thanks



Andy Becker

Illinois State Lottery





</QUOTE>

----

=== At 20 DEC 2001 04:20PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]  wrote:  ===

<QUOTE>Apologies - please try %C%



[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 26 DEC 2001 12:21PM a becker wrote:  ===

<QUOTE>You must quote the %C% as shown on the following example.



BREAK-ON LOCATION_NAME "'%C%'"

</QUOTE>


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