QR Title

Manila (5/23/14 6:00AM)
Keith Culotta (5/23/14 3:10PM)

Manila (5/23/14 6:00 AM)

Alan,

When you are generating a Quick thru code, you have to create an
Offscreen Area to contain the report while it is being formatted.
Then, after the report has been generated, you need to clear the
offscreen area to recapture that memory. Take a look at the docs for
these two commands:

QR New Offscreen Area
QR DELETE OFFSCREEN AREA

You will also need several other QR commands when formatting and
generating your report. You can pretty much control everything. The
docs are very clear on what you need to do.

HTH

Walt Nelson (Manila)

color><param>00000,0000,DDEE/param>------Original Message-----
/color>AAlan Tilson asked:
color><param>00000,0000,DDEE/param>HHello Bill,
I was able to step through the wizard and produce the code, but I am
confused about the $1 parameter which is the "area". Is this a plug in
area or a web area? And is it required that I somehow display this in
an "area"
rather than just printing it?
Thanks!
/color>
Keith Culotta (5/23/14 3:10 PM)

One way is to create a form with a Report plugin area (vReportFormObj
) and use QR REPORT TO BLOB(vReportFormObj;[Reports]ReportBlob) in a
button script, for instance. ?The form plugin can be used to create
reports or [File] open reports saved to disk. ?I have not tried
DOCUMENT TO BLOB with one of these disk files, but maybe

A report area in a form does not display all the options the editor
opened from the QR REPORT command does. I&iacute;ve not sent a report from
the Editor to a blob, only Editor -> disk -> report form object ->
blob.

Keith
?=A0?=A0?=A0?=A0?Computer Dimensions, Inc.

On May 23, 2014, at 2:19 PM, Alan Tilson <alantilson@... wrote:

color><param>00000,0000,DDEE/param>HHello Walt - thank you for the
info. I am hoping to use what Arnaud sent to
work directly from the manually created QR Reports. And I don't think
the
manuals are very clear at all, just a bunch of commands but without a
view
of how to use them. Wasn't there a separate QR manual at one time?

Hello Arnaud - I am trying this but have run into an issue. You are
starting with a [QR] table which contains a BLOB containing the report
it
seems. How do you initially get the manually created report into the
BLOB?
QR REPORT TO BLOB seems to need an off screen area containing the
report to
start with. I was hoping to load the report from the file on disk...

Thanks,
Alan

On Thu, May 22, 2014 at 6:33 PM, Arnaud de Montard <arnaud@...
wrote:

/color><color><param>8826F,0000,8219/param>
Le 22 mai 2014 &yacute; 20:51, Alan Tilson a &Egrave;crit :

/color><color><param>FFC79,0365,0771/param>HHello everyone,
I found this old thread with my question, but I don't know how to use
/color><color><param>8826F,0000,8219/param>tthis
/color><color><param>FFC79,0365,0771/param>ccommand with a report
created using the Report Editor and printed with
/color><color><param>8826F,0000,8219/param>tthe
/color><color><param>FFC79,0365,0771/param>QQR Report command. Is it
possible and if it is how is it done?
/color><color><param>8826F,0000,8219/param>
1/ ++++++++++++++
some (old) code I use to execute templates created with the Report
Editor

//QR_execute
(name{;hideDetail;destination;path;headerL;C;R;footerL;C;R)
$params_l:=Count parameters
$QRname_t:=$1
$QRzone_l:=QR New offscreen area ?//CCC
QR BLOB TO REPORT($QRzone_l;[QR]zeBlob)
If (Is table number valid([QR]numTable))
?=A0?=A0?=A0QR SET REPORT TABLE($QRzone_l;[QR]numTable)
Else
?=A0?=A0?=A0//erreur...
End if
//avec ou sans lignes de d&Egrave;tail
$masquerDetail_l:=QR Get info row($QRzone_l;qr d&Egrave;tail) ?//-2=ligne
s de
d&Egrave;tail;0=affich&Egrave;es/1=cach&Egrave;es
If ($params_l>1)
?=A0?=A0?=A0If ($masquerDetail_l#$2) & (($2=0) | ($2=1))
?=A0?=A0?=A0?=A0?=A0?=A0?=A0QR SET INFO ROW($QRzone_l;qr
d&Egrave;tail;$2) ?//0=affich&Egrave;es #
1=masqu&Egrave;es
?=A0?=A0?=A0End if
End if
//destination (imprimante | fichier) # d&Egrave;clinaisons aper&Aacute;u et pdf =
imprimante + dialogue
If ($params_l>2)
?=A0?=A0?=A0QR GET
DESTINATION($QRzone_l;$typeSortie_l;$destPath_t)
?=A0?=A0?=A0Case of
?=A0?=A0?=A0?=A0?=A0?=A0?=A0: ($3=qr imprimante) &
($typeSortie_l#$3) ?//# bug
2003.2 :
?=A0?=A0?=A0?=A0?=A0?=A0?=A0//cette instruction
r&Egrave;initialise toujours la mise en page
?=A0?=A0?=A0?=A0?=A0?=A0?=A0//c'est pourquoi on ne
l'ex&Egrave;cute que s'il y a lieu
?=A0?=A0?=A0?=A0?=A0?=A0?=A0QR SET
DESTINATION($QRzone_l;qr imprimante)
?=A0?=A0?=A0?=A0?=A0?=A0?=A0: ($3=qr fichier texte) &
($typeSortie_l#$3)
?=A0?=A0?=A0?=A0?=A0?=A0?=A0$destPath_t:=""
?=A0?=A0?=A0?=A0?=A0?=A0?=A0If ($params_l>3) ?//nom du
fichier : param&Euml;tre pass&Egrave;
?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0$destPat
h_t:=$4
?=A0?=A0?=A0?=A0?=A0?=A0?=A0End if
?=A0?=A0?=A0?=A0?=A0?=A0?=A0If ($destPath_t#"")
?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0//v&Egrave;ri
fie que ce nom ne provoque pas de conflit,
le modifie le cas &Egrave;ch&Egrave;ant
?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0$destPat
h_t:=FS_uniquename ($destPath_t)
?=A0?=A0?=A0?=A0?=A0?=A0?=A0End if
?=A0?=A0?=A0?=A0?=A0?=A0?=A0If ($destPath_t="")
?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0//#bug
2003.2 : si $destPath_t est vide, QR
EXECUTER ne fait rien
?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0//pour
&Egrave;viter cela il faut l'ex&Egrave;cuter sans le
3&Euml;me
param&Euml;tre
?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0QR SET
DESTINATION($QRzone_l;qr fichier texte)
?=A0?=A0?=A0?=A0?=A0?=A0?=A0Else
?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0?=A0QR SET
DESTINATION($QRzone_l;qr fichier
texte;$destPath_t)
?=A0?=A0?=A0?=A0?=A0?=A0?=A0End if
?=A0?=A0?=A0Else
?=A0?=A0?=A0?=A0?=A0?=A0?=A0//#destination non g&Egrave;r&Egrave;e
?=A0?=A0?=A0End case
End if
//en-t&Iacute;tes et pieds
If ($params_l>4)
?=A0?=A0?=A0QR GET HEADER AND
FOOTER($QRzone_l;1;$enTeteG_t;$enTeteC_t;$enTeteD_t;$hauteurEnTete_l)
//1=en-t&Iacute;te
?=A0?=A0?=A0QR GET HEADER AND
FOOTER($QRzone_l;2;$piedG_t;$piedC_t;$piedD_t;$hauteurPied_l) ?//2=pie
d
?=A0?=A0?=A0If ($params_l>4) ?//$5 = ent&Iacute;te gauche
?=A0?=A0?=A0?=A0?=A0?=A0?=A0$enTeteG_t:=xStrBool
(($5="*");$enTeteG_t;$5)
?=A0?=A0?=A0End if
?=A0?=A0?=A0If ($params_l>5) ?//$6 = ent&Iacute;te centre
?=A0?=A0?=A0?=A0?=A0?=A0?=A0$enTeteC_t:=Choose(($6="*");
$enTeteC_t;$6)
?=A0?=A0?=A0End if
?=A0?=A0?=A0If ($params_l>6) ?//$7 = ent&Iacute;te droite
?=A0?=A0?=A0?=A0?=A0?=A0?=A0$enTeteD_t:=Choose(($7="*");
$enTeteD_t;$7)
?=A0?=A0?=A0End if
?=A0?=A0?=A0If ($params_l>7) ?//$8 = pied gauche
?=A0?=A0?=A0?=A0?=A0?=A0?=A0$piedG_t:=Choose(($8="*");$p
iedG_t;$8)
?=A0?=A0?=A0End if
?=A0?=A0?=A0If ($params_l>8) ?//$9 = pied centre
?=A0?=A0?=A0?=A0?=A0?=A0?=A0$piedC_t:=Choose(($9="*");$p
iedC_t;$9)
?=A0?=A0?=A0End if
?=A0?=A0?=A0If ($params_l>9) ?//$10 = pied droite
?=A0?=A0?=A0?=A0?=A0?=A0?=A0$piedD_t:=Choose(($10="*");$
piedD_t;$10)
?=A0?=A0?=A0End if
?=A0?=A0?=A0QR SET HEADER AND
FOOTER($QRzone_l;1;$enTeteG_t;$enTeteC_t;$enTeteD_t;$hauteurEnTete_l)
//1=en-t&Iacute;te
?=A0?=A0?=A0QR SET HEADER AND
FOOTER($QRzone_l;2;$piedG_t;$piedC_t;$piedD_t;$hauteurPied_l) ?//2=pie
d
End if
If (Shift down) ?//test aper&Aacute;u (forum, B. Escaich)
?=A0?=A0?=A0QR EXECUTE COMMAND($QRzone_l;qr cmd apercu)
Else
?=A0?=A0?=A0QR RUN($QRzone_l)
End if
QR DELETE OFFSCREEN AREA($QRzone_l) ?//CCC

2/ ++++++++++++++
This one uses a qr area to print a selection listbox:
<http://forums.4d.fr/Post/FR/14382576/1/14382577#14387836>
lines 42/43 show header/footer insertions too

--
Arnaud de Montard
/color>
Reply to this message

Summary created 5/23/14 at 5:13PM by Intellex Corporation

Comments welcome at: feedback@intellexcorp.com