Jim, I store my photos outside of the database. I have a table with the file name that links to a unique patient ID. The report that generates the PDF pulls the photo into the report. It is a very clean and simple process.
John From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, December 18, 2009 10:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Converting JPGs to PDF in Rbase Since BMPs are actually screen shots of drawings (photos), I would think it should work. I will have to test it. In your code, do you bring your pictures in as variables prior to running the code you sent to the list? Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Friday, December 18, 2009 9:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Converting JPGs to PDF in Rbase Jim, I haven't tried it with BMPs but I feel sure it would work. I use the code to create a PDF file from a series of selected patient photos (JPG) and comments. John From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Friday, December 18, 2009 10:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Converting JPGs to PDF in Rbase John, Can I assume converting from BMP to PDF would be the same? Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Friday, December 18, 2009 9:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Converting JPGs to PDF in Rbase Michael, Here is a snippet of code that I use to create a PDF from JPGs. Of course, you will need to change the variables to match your application. SET VAR vpdf_file TEXT = + ('C:\Documents and Settings\'+.vwin_user+'\My Documents\'+.vfml) PRINT patient_pic + WHERE cust# = .vcu_no AND PIC_FLAG = 'T' + OPTION PDF + |FILENAME .vPDF_FILE + |TITLE PATIENT PHOTOS + |SUBJECT .vFML + |AUTHORIZATION .vCO_ADD_LINE1 + |USE_COMPRESSION ON + |COMPRESSION_METHOD MAXCOMPRESS + |INCLUDE_IMAGES ON + |IMAGE_FORMAT JPG + |PIXELFORMAT 32 + |JPEG_QUALITY 100 + |IMAGE_DPI -1 + |OPEN ON RETURN John From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair Sent: Friday, December 18, 2009 10:00 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Converting JPGs to PDF in Rbase Is there any way, from within Rbase to convert a group of JPGs into a single PDF file? Mike
