Count and SLIST/RList (OpenInsight 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 20 DEC 2001 12:27:15PM a becker wrote:

OpenInsight Specific

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

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:

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 "

The Sprezzatura Group

World Leaders in all things RevSoft

At 20 DEC 2001 02:01PM a becker wrote:

Thanks, I'll give it a try.

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

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

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:

Apologies - please try %C%

The Sprezzatura Group

World Leaders in all things RevSoft

At 26 DEC 2001 12:21PM a becker wrote:

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

BREAK-ON LOCATION_NAME "'%C%'"

View this thread on the forum...