This is a example with the requirement exactly i am looking for and works fine for pdf.
How does this work for exl2k format...
DEFINE FILE CAR LOGO/A100=IF COUNTRY EQ 'ENGLAND' THEN 'D:\ibi\apps\ibisamp\SMPLOGO1.GIF' ELSE IF COUNTRY EQ 'ITALY' THEN 'D:\ibi\apps\ibisamp\HWCOT.GIF' ELSE 'D:\ibi\apps\ibisamp\SMPLOGO1.GIF'; END
TABLE FILE CAR SUM CAR COUNTRY BY LOGO ON TABLE SET HTMLCSS ON ON TABLE SET ONLINE-FMT PDF ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL, $ TYPE=DATA, COLUMN=N1, IMAGE=(LOGO),SIZE=(.5 .5),PRESERVERATIO=ON,$ ENDSTYLE END -EXITThis message has been edited. Last edited by: Kerry,
7.7.02, sql server Windows all output (Excel, HTML, PDF)
September 03, 2010, 06:36 AM
Senthilvasan S
Image cannot be positioned in excel output. Please raise a ticket with IBI.
WebFOCUS 7 6 9 Windows XP HTML, AHTML, PDF, EXCEL
September 03, 2010, 07:02 AM
Anmol
You can position the image in excel output .....
here is the code which displays in each row depending on the condition
-SET &&LOGO1 = 'D:\ibi\apps\ibisamp\SMPLOGO1.GIF';
-SET &&LOGO2 = 'D:\ibi\apps\ibisamp\HWCOT.GIF';
-SET &&LOGO3 = 'D:\ibi\apps\ibisamp\SMPLOGO1.GIF';
DEFINE FILE CAR
LOGO/A100= IF COUNTRY EQ 'ITALY' THEN '<img src="&&LOGO1.EVAL" border="0"></img>' ELSE
IF COUNTRY EQ 'ITALY' THEN '<img src="&&LOGO2.EVAL" border="0"></img>'
ELSE '<img src="&&LOGO3.EVAL" border="0"></img>';
END
TABLE FILE CAR
PRINT
CAR
COUNTRY
LOGO
ON TABLE SET HTMLCSS ON
ON TABLE SET ONLINE-FMT EXL2K
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA, COLUMN=N1,$
ENDSTYLE
END
-EXIT
hope this helps.... Anmol.
WebFocus7.6.2, WebFocus 7.1.1,Windows HTML, PDF and Excel
September 03, 2010, 09:38 AM
Prasad
Thank you very much..
I tried the solution what you have posted... It is not able to retrive the image insted it shows a small box with a red cross mark on it....
What could be the reason fot it...
7.7.02, sql server Windows all output (Excel, HTML, PDF)
September 03, 2010, 10:02 AM
Kofi
quote:
It is not able to retrive the image insted it shows a small box with a red cross mark on it....
This is being joke? yes?
If you use code exact from Anmol and you no haf the image in exact place given, then image is being not found and you haf the "image not be found" icon.
You haf be coding yourself a little to show you understand - it be obviously that you not haf knowledge of image use in output and web.
Kofi
Client Server 8.1.05: Apache; Tomcat;Windows Server 2012 Reporting Server 8.1.05; Oracle; MS SQL; Windows Server 2012
September 06, 2010, 01:37 AM
Anmol
quote:
fine
Prasad, showing Cross red sign in the box means it is not able to locate the image file specified in the path check out that the specified images are available at the below path(location).
D:\ibi\apps\ibisamp\*.gif
Anmol
WebFocus7.6.2, WebFocus 7.1.1,Windows HTML, PDF and Excel
September 07, 2010, 12:14 PM
Prasad
Thank You very much Anmol.
7.7.02, sql server Windows all output (Excel, HTML, PDF)