{{tag>category:"OpenInsight 32-Bit" author:"Mike Norton" author:"Colin Rule" author:"support@sprezzatura.com" author:"Michael Norton" author:"Dave Harmacek" author:"Mike Ruane" author:"Alun Hutchings"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== RLIST  (OpenInsight 32-Bit) ====
=== At 15 MAR 2005 09:04:41AM Mike Norton wrote: ===
 
 
<QUOTE>
This is probably a bit of an "old chestnut" but it's driving us up the wall. Need to build a report using BREAK-ON options.



RUN RLIST "LIST PATIENTS WITH ADMITTED_DATE ]= '01/01/05' AND WITH ADMITTED_DATE <= '31/03/05' BY CONSULTANT BREAK-ON CONSULTANT 'V' TOTAL UNIT ID-SUPP DET-SUPP","1"



(UNIT is just a calcuated column (@ANS=1) to aid counting etc.)



Have seen recommendations to use System Monitor and have tried that with no joy, request works with 'V' missing, fails with "SYS1240:  A comma or quote is missing in the script." error if use "'V'" (as described in manual) and in the form above have no errors but equally have no output!
</QUOTE>
----

=== At 15 MAR 2005 09:16AM Colin Rule wrote:  ===

<QUOTE>May not be the answer, but isn't the V supposed to be in single quotes within double quotes with optional text either side, ie



" blah 'V' blah "



Colin

</QUOTE>

----

=== At 15 MAR 2005 09:24AM support@sprezzatura.com wrote:  ===

<QUOTE>You can't issue this from either the system editor or system monitor because both types of quotes are required.



sentence=LIST PATIENTS WITH ADMITTED_DATE ]= "01/01/05" AND WITH ADMITTED_DATE = "01/01/05" AND WITH ADMITTED_DATE The Sprezzatura Group Web Site

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

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

</QUOTE>

----

=== At 15 MAR 2005 09:38AM Michael Norton wrote:  ===

<QUOTE>Thanks guys, I was sort of hoping there was a work around for System Editor so client could have a quick fix today but hey-ho......don't suppose there is any chance Revelation would like to take this on an introduce a third set of "quote delimiters", I seem to remember some old PICK systems used to accept / marks in place of quotes to avoid similar issues.

 

</QUOTE>

----

=== At 15 MAR 2005 10:20AM Dave Harmacek wrote:  ===

<QUOTE>Why don't you make up a form with an EditBox for the statement and a RUN button?

</QUOTE>

----

=== At 15 MAR 2005 10:25AM support@sprezzatura.com wrote:  ===

<QUOTE>A third party reporting product allows this, but I don't think we're allowed to self-promote S/List without prior permission.





support@sprezzatura.com

The Sprezzatura Group Web Site

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

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

</QUOTE>

----

=== At 15 MAR 2005 10:44AM Mike Ruane wrote:  ===

<QUOTE>Have you tried this from TCL?

</QUOTE>

----

=== At 15 MAR 2005 11:10AM Mike Norton wrote:  ===

<QUOTE>Hi Mike, I've tried it from Exc: line in System Editor and System Monitor, same problem in both environments

</QUOTE>

----

=== At 16 MAR 2005 10:49AM Alun Hutchings wrote:  ===

<QUOTE>If you are using system monitor you must enclose the V with one single quote and two sets of double-quotes. You can also use between dates so...

 

RUN RLIST "LIST PATIENTS WITH ADMITTED_DATE BETWEEN '01/01/05' AND '31/03/05' BY CONSULTANT BREAK-ON CONSULTANT ""'V'"" TOTAL COUNT ID-SUPP DET-SUPP","1"



is what you really need (I think)



</QUOTE>


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