IMG_LOGO_1/A500V = '<IMG SRC="'||BASE_PATH_LOGO_1||'" width=150px height=90px >';
IMG_LOGO_2/A500V = '<IMG SRC="'||BASE_PATH_LOGO_2||'" width=150px height=90px >';
And then in the HEADING i use them
" <+0> <+0> <+0> <+0> <+0> "
"<IMG_LOGO_1 <+0>Report Name<+0> <IMG_LOGO_2"
And i give proper location using LINE and ITEM in the style sheet to place them on the left and right corner.
This also works.
For EXCEL(XLSX) ; I tried the first method i used for PDF,it works,but both logos will appear at the same location,on the left corner even though i have the position given. I tried the second method,and it gives the image url on the left and right corner ,but not the image.
Not what i am missing here.. Please suggest any idea.This message has been edited. Last edited by: srajeevan,
WF8202M,Windows 7,8,10 HTM,PDF,EXCEL
February 13, 2019, 04:53 AM
Hi, I found this code in the help file that might help you. Change the format to xlsx
TABLE FILE GGSALES
SUM DOLLARS UNITS BUDDOLLARS BUDUNITS
ON TABLE SET BYDISPLAY ON
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *
TYPE=TITLE, COLOR=WHITE, BACKCOLOR=GREY,$
TYPE=PAGEHEADER, OBJECT=IMAGE, JUSTIFY=LEFT, IMAGE=IBI_LOGO.GIF, DISPLAYON=FIRST,$
TYPE=PAGEHEADER, OBJECT=IMAGE, JUSTIFY=RIGHT, IMAGE=IBI_LOGO.GIF, DISPLAYON=NOT-FIRST,$
TYPE=PAGEFOOTER, OBJECT=IMAGE, JUSTIFY=CENTER, IMAGE=webfocus1.gif, $
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
February 13, 2019, 05:12 AM
xlsx format report currently do not support two images on two different paces i.e. header or footer. Above code @Addy has given will change look and feel of xlsx report completely. You can use either exl2k format report or can photoshop and merge all image into single image, then place this image in report. in xlsx format, image will always appear on the top left corner .This message has been edited. Last edited by: Tulsi,