I think this is what I was looking for, Javier. Let me test it and I'll let you know!
Thanks! Karen -----Original Message----- From: Javier Valencia <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, May 28, 2013 1:08 pm Subject: [RBASE-L] - RE: Images in report Karen. I have not worked on reports with photos in a while, since all the ones I need were developed a while back and have been working reliably. Anyway, I looked at one of the reports that uses photo/image names stored in the database and the actual photo in a subdirectory and this is what I do: The directory where the photos are stored is defined as: SET VAR veq_pdir = ((CVAL('CURRDIR')) + '\EQUIP_PHOTOS\') In the report I define a variable : vUnit_Photo as TEXT ( .veq_pdir + equip_photo_file ) -- This is defined under report variables Where equip_photo files is a TEXT column that stores the photo file name as: D-2302-G_10_01_2003_16_44_17.JPG In the report I locate a Variable Image where I want the image to display with the variable name vUnit_Photo. The report display the image for that record correctly. When the image is stored in the database, such a logo, in the report I define a variable; vLogo as VARBIT org_logo IN orgfile WHERE orgno = 'VTG' -- This is defined under report variables and then I place a Variable Image object where I want to display the image with the variable name vLogo The report display the image d correctly. Hopefully this is what you had in mind, if not send me an e-mail and can prepare a quick sample for you Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Tuesday, May 28, 2013 11:07 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Images in report Remind me... In the past when I had to locate an image on a report and the filename is something that changes based on the record being printed, I used to define a VARBIT variable outside the report, like this: SET VAR vCommand = + ('SET VAR vSignature VARBIT = [' + cval('quotes') + + .xvName + 'Signature.JPG' + cval('quotes') + ']' ) &vCommand I played around a little and didn't seem to find the right way to do this using Report Variables only. Using 9.5, 32 bit. Is there anyway I can do this using report variables? I know I can put this on the Before Generate eep but I prefer variables because they're more "visible". Karen
