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
