John,
At the beginning of the year, I am making some major changes to the database. One change is to implement what you mentioned below for the parts we make. Instead of having the BMP in a table, I plan to go to a specific location as you mentioned below and print the BMP. What would be the best way to rotate the image so it prints the picture as landscape on the second page? In other words, the main information about the part would be on the first page and the second page would only have the picture. Instead of the picture printing as a portrait on the same page, I would want a new page and the image as landscape. The image is in the Footed band based on the part number. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Friday, December 18, 2009 10:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Converting JPGs to PDF in Rbase 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
