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,
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
In Focus since 2006
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,
Thanks for the response.
|Powered by Social Strata|