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

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.

]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

View this thread on the forum...