RE: [sqr-users] Generating PDF output from SQR

[Jagadis.Mithilesh@hartfordlife.com]

Thank you for your quick response Jeff.

But we launch it in the UNIX environment with the following command:

system("sqr e400301r {Userid/Passwd} $P1 $P2 $P3 $P4 $P5 -Me400301r.txt
-PRINTER:PS -ZIF$SQRINI -F$Cdssqrout -E$Cdssqrerr");

I could see that we have also used the parameter -PRINTER with :PS (for
post script which I understand now). Do you think if I just change this :PS
with :PD I will get a PDF output instead? Or do I think I need to make some
more changes to this command for me to have the PDF output. Please note
that $P5 (the fifth parameter being passed to the program) contains the
printer que to which the output gets printed.

Thanks
Jags.


                                                                                
                                                         
                      Jeff.Steinfeldt@wel                                       
                                                         
                      lsfargo.com                To:       
Jagadis.Mithilesh@hartfordlife.com                                            
                                                 cc:                            
                                                         
                      01/20/2005 09:05 AM        Subject:  RE: [sqr-users] 
Generating PDF output from SQR                                
                                                                                
                                                         
                                                                                
                                                         




We are executing SQTs from within an SQR.  We use the -printer:pd
command-line parameter to generate PDF directly as on line 5 below.

                                     LET $cmd = ''
                                     LET $cmd = $cmd || 'C:\Program
Files\Brio\SQR\ODB\BINW\sqrwt.exe '
                                     LET $cmd = $cmd || $RptSQTName || ' '
! Report to run
                                     LET $cmd = $cmd || $Connectivity
! Database to connect to

                                     LET $cmd = $cmd || '-XMB -E' ||
$RptLogName || '
-printer:pd '

                                     LET $cmd = $cmd || '-F' || $Dir_Report
|| ' '
! Set destination for the PDF files
                                     LET $cmd = $cmd || '''--PK ' ||
$PrimaryKey || ''' '
! Command-line argument

                                     !           Execute the report via
sqrwt.exe and wait
for it to complete
!                                    DISPLAY $cmd
                                     CALL SYSTEM USING $cmd #Twitch WAIT




Causes printer type xx to be used when creating output files.

xx           Printer Type            Example
             EH          Enhanced HTML           -PRINTER:EH
             EP          Enhanced HTML and PDF         -PRINTER:EP
             HP          HP LaserJet             -PRINTER:HP
             HT          HTML 2.0          -PRINTER:HT
             LP          Line Printer            -PRINTER:LP
             PD          PDF         -PRINTER:PD
             PS          PostScript        -PRINTER:PS
             WP          Windows           -PRINTER:WP


-----Original Message-----
From: sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org
[mailto:sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org] On
Behalf Of Jagadis.Mithilesh@hartfordlife.com
Sent: Thursday, January 20, 2005 8:00 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Generating PDF output from SQR


Hi

Is it possible to generate a PDF output file from a SQR program directly.

The current architecture is that we call the SQR program from a PERL script
and collect the print from the printer. I would also like to get a soft
copy
of the output generated by the SQR and preferably in PDF format.

Any help will be appreciated.

Thanks
Jags.



*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is
for the exclusive use of addressee and may contain proprietary,
confidential
and/or privileged information.  If you are not the intended recipient, any
use, copying, disclosure, dissemination or distribution is strictly
prohibited.  If you are not the intended recipient, please notify the
sender
immediately by return e-mail, delete this communication and destroy all
copies.
*************************************************************************


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users