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


==== Reporter and System Variables (OpenInsight Specific) ====
=== At 02 SEP 1998 06:37:47PM DSig  (SigSOlutions) wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
How can you access System Variables like @Username in a report?  AND how would you define a selection with field=todays date".  I have looked in the docs and not found such animal.  If it is there just point me in the right direction ..



thanks



dsig

David Tod Sigafoos ~ SigSolutions

dsig@teleport.com
</QUOTE>
----

=== At 03 SEP 1998 01:20AM Paul Rule wrote:  ===

<QUOTE>How about if you make a couple of symbolics.

One called "TODAY" that has @ans=date()

So your selection criteria could using something like, SELECT FILE WITH DATEFIELD=TODAY

Same for @USERNAME

@ANS=@USERNAME

Is this what you mean or am I missing the point.

Hope this helps.



</QUOTE>

----

=== At 03 SEP 1998 07:57AM Richard Bright NZ wrote:  ===

<QUOTE>]How can you access System Variables like @Username in a report? 



I found likewise that System variable s which SHOULD be available, were not.  (The issue becomes more interesting when you define global variables.)

However you can access these per form by creating a "Calculated field" and, like the symbolic set @ANS=@User_Name etc

</QUOTE>


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