Focal Point
[Solved]Logo on the right and left corner - XLSX Output format

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6797001196

February 12, 2019, 03:03 PM
srajeevan
[Solved]Logo on the right and left corner - XLSX Output format
Hi,

I have a report with 4 different output format such as HTML,AHTML,PDF,EXCEL.

I have different style sheet code for each of them.
In the report i have to display a logo at the right corner and another logo at the left corner.

For PDF Output I ave used the below trick:
  
TYPE=HEADING,
     IMAGE=IBFS:/WFC/Repository/App1/Images/Logo_1.jpg,
     POSITION=(+0.041667 +0.000000),
     SIZE=(1.700000 1.000000),
	 JUSTIFY=LEFT,
$
TYPE=HEADING,
     IMAGE=IBFS:/WFC/Repository/App1/Images/Logo_2.jpg,
     POSITION=(+10.0000 +0.000000),
     SIZE=(1.7 1.000000),
	 JUSTIFY=RIGHT,
$


This is working for PDF.

For AHTML output format,

I created a defines as below,

  
BASE_PATH_LOGO_1/A600 ='WFServlet.ibfs?IBFS1_action=RUNFEX&|IBFS_path=/WFC/Repository/App1/Images/logo_1.jpg';
IMG_LOGO_1/A500V = '<IMG SRC="'||BASE_PATH_LOGO_1||'" width=150px height=90px >';

BASE_PATH_LOGO_2/A600 ='WFServlet.ibfs?IBFS1_action=RUNFEX&|IBFS_path=/WFC/Repository/App1/Images/logo_2.jpg';
IMG_LOGO_2/A500V = '<IMG SRC="'||BASE_PATH_LOGO_2||'" width=150px height=90px >';

And then in the HEADING i use them

HEADING
" <+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
Addy
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 
BY REGION
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SET BYDISPLAY ON
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *
FONT=ARIAL,SIZE=12,
XLSXPAGESETS=ON,TOPMARGIN=1,BOTTOMMARGIN=1,ORIENTATION=LANDSCAPE,
PAGESIZE=LETTER,$
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, $
END
  


https://infocenter.information...ource%2Ftopic108.htm


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006
February 13, 2019, 05:12 AM
Tulsi
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,


webfcous 8202m
windows 7
February 14, 2019, 02:04 PM
srajeevan
Thanks for the response.


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL