Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]Logo on the right and left corner - XLSX Output format
Go
New
Search
Notify
Tools
Reply
  
[Solved]Logo on the right and left corner - XLSX Output format
 Login/Join
 
Platinum Member
posted
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
 
Posts: 207 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 6 | Registered: July 25, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks for the response.


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 207 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]Logo on the right and left corner - XLSX Output format

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.