Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Image in a row of exl2k output

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Image in a row of exl2k output
 Login/Join
 
Silver Member
posted
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
-EXIT

This message has been edited. Last edited by: Kerry,


7.7.02, sql server
Windows
all output (Excel, HTML, PDF)
 
Posts: 38 | Registered: April 26, 2010Report This Post
Member
posted Hide Post
Image cannot be positioned in excel output. Please raise a ticket with IBI.


WebFOCUS 7 6 9
Windows XP
HTML, AHTML, PDF, EXCEL
 
Posts: 24 | Registered: April 24, 2009Report This Post
Gold member
posted Hide Post
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
 
Posts: 71 | Registered: June 30, 2009Report This Post
Silver Member
posted Hide Post
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)
 
Posts: 38 | Registered: April 26, 2010Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 106 | Registered: April 06, 2009Report This Post
Gold member
posted Hide Post
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
 
Posts: 71 | Registered: June 30, 2009Report This Post
Silver Member
posted Hide Post
Thank You very much Anmol.


7.7.02, sql server
Windows
all output (Excel, HTML, PDF)
 
Posts: 38 | Registered: April 26, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Image in a row of exl2k output

Copyright © 1996-2020 Information Builders