Logical name for report in QUIZ

Murray Scholz murray.scholz@abri.une.edu.au
Thu, 27 Jun 2002 09:17:07 +1000


Hello Etienne,

Allison's solution is what we would normally do too, but if you REALLY
want to set it from INSIDE the quiz, you could try....

access filename
define username char*12 = logonid
define reptname char*30 = "myreport_" + trunc(username) + ".txt"
define a1 char*1 = "Y" if setsystemval("aaa",reptname,logical)
set rep dev disc name aaa
report fieldname
go

This will create a file myreport_xxxxxx.txt for you...

Murray Scholz
Agricultural Business Research Institute
University of New England
Armidale NSW 2351 Australia




"Hamilton, Allison" wrote:
> 
> Hmmm..   I tried it and it worked for me
> I defined
> Def xx fred.txt
> QUIZ
> define yy char*3 = "432"
> set report device disc name xx
> report all
> go
> 
> and it created fred.txt
> 
> I also
> define variable fred2.txt
> QUIZ
> define yy char*3 = "342"
> set report name variable
> report all
> go
> 
> and it created fred2.txt
> 
> I also tried it with
> define variable <username>report1
> 
> and it created <username>report1.txt
> 
> The only thing that I can think of is that you are defining the logical in a
> subprocess and running QUIZ in another, perhaps.  In that case, just add the
> /JOB option to the define so all the subprocesses will see the define.
> 
> -----Original Message-----
> From: Etienne Rompré [mailto:rompre@rompre.qc.ca]
> Sent: Wednesday, June 26, 2002 1:38 PM
> To: Powerhouse List
> Subject: Logical name for report in QUIZ
> 
> Hi to all,
> 
> We want to set up report names using logical names in QUIZ.
> 
> First we define a variable that is the LOGIN ID + reportname
> 
> And then use this line of code:
> 
> SET REPORT NAME VARIABLE
> 
> The proble is that we we execute the report, QUIZ save the report on the
> drive as VARIABLE.TXT
> 
> Does anyone know of a solution in QUIZ to use logical names for reports
> 
> We are on OpenVMS 7.3 and Powerhouse 8.30Z1
> 
> Thanks!
> 
> --
> Etienne Rompré
> Superviseur / Supervisor
> 
> Location Rompré Ltée
> Québec Canada
> 
> tél: (418) 683-0400
> fax: (418) 683-5157
> courriel/email: rompre@rompre.qc.ca
> internet:  http://www.rompre.qc.ca/
>