Normal Topic Images in Reports (Read 7060 times)
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Images in Reports
May 30th, 2021 at 3:58pm
Print Post Print Post  
I have saved QR Code images in my inventory database.  The QR codes provide links to our web site.  I've printed the QR codes and attached them to our price tags.  This way our salesreps or customers can get information on these items using their smart phones.  I can see the QR Codes when I search items in the inventory. 

Is there any way to make them visible when I do a report? 

I was able to add a hyperlink to the picture file for the QR Code, but not the actual code.  When I click on the hyperlink to the file, it appears with a black background.  The black background is the problem.  Is there a way to change the background with the hyperlink command?
« Last Edit: May 31st, 2021 at 2:58pm by cbislander »  

20210530_125702.jpg ( 445 KB | 56 Downloads )
20210530_125702.jpg
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Images in Reports
Reply #1 - Jun 1st, 2021 at 2:18pm
Print Post Print Post  
Are you using an HTML report designed in Sesame Designer?

If you are just add the image field to the report and then in Global Code of that report, put the following line of code

Code
Select All
ReportHTMLFilter("SesameReports\", "", 0) 



What that lines does is remove the Sesame report path from the path for the images that the report generation code is erroneously putting into them.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Images in Reports
Reply #2 - Jun 1st, 2021 at 2:56pm
Print Post Print Post  
It worked when I did the initial report, but the other codes are stored at a preset 370x370 which looks too large for the report.  How do I downsized the image for the report without manually resizing each image?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Images in Reports
Reply #3 - Jun 1st, 2021 at 4:48pm
Print Post Print Post  
If you want every image to display as say 100 by 100 put this code into Global Code of the report

Code
Select All
ReportHTMLFilter("<IMG SRC=", "<IMG WIDTH=""100"" HEIGHT=""100"" SRC=", 2) 



-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Images in Reports
Reply #4 - Jun 1st, 2021 at 7:27pm
Print Post Print Post  
That works perfectly.

Thanks Ray

  
Back to top
 
IP Logged