Logical name for report in QUIZ
Etienne Rompr=?ISO-8859-1?B?6Q==?=
rompre@rompre.qc.ca
Thu, 27 Jun 2002 10:58:46 -0400
Thanks Murray,
Your solution worked exactly like we wanted it to do.
Also, thanks to everyone that answered my request.
--
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/
> 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/
>>
>