{{tag>category:"None Specified" author:"Glen Hawken" author:"David Pociu" author:"Tracy Graves Revelation"}}

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


==== Reporter Criteria handling (None Specified) ====
=== At 07 APR 1998 10:01:35PM Glen Hawken wrote: ===
 
 
<QUOTE>
I'm trying to send critieria to reporter so it gathers the appropriate record with a concatenated key.  eg. within reporter the criteria can read 'WITH @ID=1*5"'.  However this same criteria will return 



Error in script

Invalid words: WITH'

Critieria will not be saved containing errors.. then subsequent illegal operation crash in Reporter.



I could split the key up and call it individually, but this is inefficient and non-standard.  The guts of our generic print routine is as follows:



  COMMAND=REPORTER.EXE'

  COMMAND := ' /AP=:@DBID

  COMMAND := ' /UN=:@USERNAME

  COMMAND := ' /RP=:LAYOUT

  COMMAND := ' /SEL=:CRITERIA

  COMMAND := ' /SELTYPE=revelationbasic'

  COMMAND := ' /RE=1'       ;* load report from repos

  IF SOURCE THEN

    LB_STATUS_LINE('Preparing to Print: ':FORM.DISPLAY:' Layout ':FORMAT,1)  

    COMMAND := ' /PR=1'     ;* bypass design and print

    DO.NOT.DISPLAY.DIALOG=XLATE('SPK_DEFAULTS','SETTINGS',70,'X')

    IF DO.NOT.DISPLAY.DIALOG THEN

      COMMAND := ' /BA=1'   ;* do not show print dialog box

    END

  END ELSE

    LB_STATUS_LINE('Preparing to Preview: ':FORM.DISPLAY:' Layout ':FORMAT,1)

    COMMAND := ' /PV=1'     ;* bypass design and preview

  END

  COMMAND := ' /QU'         ;* quit after print

  ORIG=SET_PROPERTY('SYSTEM','BLOCK_EVENTS',1)

  CALL UTILITY('RUNWIN',COMMAND,'')

  BACK=SET_PROPERTY('SYSTEM','BLOCK_EVENTS',ORIG)  
</QUOTE>
----

=== At 07 APR 1998 10:37PM David Pociu wrote:  ===

<QUOTE>Glen,



I would use GETLIST in the Report. Select your keys using an RLIST statement in your subroutine first, then call the report which will get the list of stored keys. 



I found this to be the most reliable way of selecting data from a table for report purposes.

</QUOTE>

----

=== At 08 APR 1998 10:33AM Tracy Graves Revelation wrote:  ===

<QUOTE>In addition to what Dave said, you can find this documented in the knoledge base.

[url=http://www.revelation.com/WebSite/knowledge.nsf/88e0581886ff6a0d8525651c004caecf/bb2ba418864d3302852565370049a963?OpenDocument]Printing Single or Multiple Records in Reporter[/url]



Tracy

</QUOTE>

----

=== At 09 APR 1998 03:55AM Glen Hawken wrote:  ===

<QUOTE>

</QUOTE>


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