Since not all the parts will have PDF files, I will need to check the
folder with the PDF files.
If the folder does not have the specific file, I want to print a
different report.
I create a temp table that includes the col. Partnum. These are the
parts we want travelers for.
I then want to check, BEFORE PRINTING, the folder with the PDF files
against the DISTINCT partnum field in this temp table.
If there is a PDF for the parts, I will use the report with the PDF
function.
If not, I will use a different report.
I have used this code to check for a single file.
SET VAR vChkSpec INTEGER = (CHKFILE(.vTotpath))
IF vChkSpec < 1 THEN
information
ENDIF
Would it be better to use a CURSOR function with WHILE Loop for this?
I have done this recently where I choose one of two reports based on
criteria.
If I went this direction, I would have to be able to close adobe after
printing each part number.
Any suggestions?
James Belisle
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt
Dove
Sent: Thursday, January 13, 2011 1:41 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Print Pdf within report
Look at Razzak's example. He is building up a string to launch Acrobat
with parameters that print the document, not display it on the screen.
The /p and /h do that.
Emmitt Dove
Converting Systems Architect
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
From: [email protected] [mailto:[email protected]] On Behalf Of Jim
Belisle
Sent: Thursday, January 13, 2011 14:13
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Print Pdf within report
Emmitt,
I did use the LAUNCH command as mentioned in the email I just sent and
it printed to the screen.
Since I want to automate this so it goes immediately to the printer, I
assume I need to add parameters.
I need to do this because the production manager does not want to have
to hit print for each part we are working on.
If I have 20 parts we are working on this is what I want:
Each traveler will print (they have the processes in order) then the PDF
associated with that part.
This would happen 20 times as one print job.
What parameters would I need to add to the LAUNCH command to accomplish
this?
James Belisle
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt
Dove
Sent: Thursday, January 13, 2011 12:49 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Print Pdf within report
Jim,
You can use the LAUNCH command to launch acrobat and print the file.
The following is from a message written by Razzak some years back:
{Define Print String
If Using Full Version of Adobe Acrobat 8.0
C:\Program Files\Adobe\Acrobat 8.0\Acrobat\Acrobat.exe
If Using Adobe Acrobat 8.0 Reader Only
C:\Program Files\Adobe\Acrobat 8.0\Reader\AcroRd32.exe
If Using Full Version of Adobe Acrobat 9.0
C:\Program Files\Adobe\Acrobat 9.0\Acrobat\Acrobat.exe
If Using Adobe Acrobat 9.0 Reader Only
C:\Program Files\Adobe\Acrobat 9.0\Reader\AcroRd32.exe}
SET VAR vPrintString = +
(.vQuotes+'C:\Program Files\Adobe\Acrobat 8.0\Acrobat\Acrobat.exe|/p
/h' +
&.vPDFFilename+.vQuotes)
LAUNCH &vPrintString
This is not the complete message, and Razzak was demonstrating how to
print a report to a PDF then immediately send the PDF to the printer.
So, for instance, his syntax relies upon having your quote setting in
the variable vQuotes.
To accomplish your goal, print your report then send the PDF to the
printer using Acrobat.
Emmitt Dove
Converting Systems Architect
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
From: [email protected] [mailto:[email protected]] On Behalf Of Jim
Belisle
Sent: Thursday, January 13, 2011 13:35
To: RBASE-L Mailing List
Subject: [RBASE-L] - Print Pdf within report
I have a report that prints an RTF file within a report using a Variable
Rich Text Object.
I now want to do the same for a PDF file.
The PDF files are in a file folder outside of RBASE,
S:\Part_PDF\filename.PDF.
I created a variable vPartPath that points to the specific file.
That part works.
My questions:
Which Variable Object should I use in the report?
I want to have the pdf print separately from the rest of the report.
James Belisle
