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.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
I had a procedure that used to work on v7703 now it does not. This just embeds images from our network drive into a PDF/HTML output report. Here's some sample code, I placed the image on the C: drive of the server, it displays the picture name with an APP QUERY command, but the image is not shown.
DEFINE FILE CAR IMAGEG/A20 = 'IMG_6083.jpg'; END TABLE FILE CAR SUM IMAGEG AS '' NOPRINT BY TYPE WHERE TYPE EQ 'SEDAN'; ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * $ TYPE=HEADING, PRESERVERATIO=ON, IMAGE=(IMAGEG), POSITION=(6.200000 2.550000), SIZE=(2.000000 1.000000), $ ENDSTYLE ENDThis message has been edited. Last edited by: Joe Beydoun,
version 8202M Reporting Server on Windows Server using DB2 Connect to access data from iseries.
Sorry, I don't understand the difference between the reporting server and the WebFOCUS repository, I believe it's in the repository.
I'm just trying to get an image in the Header, the actual code reads an item number, concatenates a .jpg and dynamically attaches the image belonging to the query. I can't get an image to display through the style sheet.
version 8202M Reporting Server on Windows Server using DB2 Connect to access data from iseries.
This works for me for PDF in 8.1.05. I had to add a HEADING to get it to work though.
APP MAP IMAGES C:\ibi\WebFOCUS81\ibi_html\javaassist\
APP PREPENDPATH images
APP QUERY images
DEFINE FILE CAR
IMAGEG/A20 = 'mrlogo.jpg';
END
TABLE FILE CAR
HEADING
" "
SUM
IMAGEG AS '' NOPRINT
BY TYPE
WHERE TYPE EQ 'SEDAN';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
$
TYPE=HEADING, PRESERVERATIO=ON,
IMAGE=(IMAGEG),
POSITION=(6.200000 2.550000),
SIZE=(2.000000 1.000000),
$
ENDSTYLE
END
It does not work for me when I change PDF to HTML in 8.1.05.
WebFOCUS 8.2.06
Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010
APP MAP IMAGE D:\ibi\WebFOCUS81\webapps\webfocus\tools\portal\resources\images\
APP PREPENDPATH image
APP QUERY image
DEFINE FILE CAR
TRUCK/A50V='distribution_list_16.png';
FLAG/A50V = DECODE COUNTRY ( 'ENGLAND' 'language_english_uk_16.png' 'ITALY' 'language_italian_16.png'
'FRANCE' 'language_frenchstandard_16.png' 'JAPAN' 'language_japanese_16.png' 'W GERMANY' 'language_german_16.png' );
END
TABLE FILE CAR
PRINT TRUCK NOPRINT AND MODEL AS ''
BY COUNTRY NOPRINT AS ''
BY FLAG AS ''
BY CAR AS ''
ON COUNTRY UNDER-LINE
ON COUNTRY SUBHEAD
"Cars produced in <ST.COUNTRY"
HEADING
" <+0>Car Manufacturer Report"
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
-**************************
-* Lines between asterisk lines required for BLOB image support
-* for HTML and DHTML formats.
ON TABLE SET HTMLEMBEDIMG AUTO
-* Required to support IE8 with images larger than 32K
ON TABLE SET HTMLARCHIVE ON
-*Required for image positioning in subheads in HTML reports
ON TABLE SET HTMLCSS ON
-**************************
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT='CALIBRI', GRID=OFF, $
TYPE=HEADING, IMAGE=(TRUCK), $
TYPE=HEADING, SIZE = 16, STYLE = BOLD, $
TYPE=SUBHEAD, IMAGE=(FLAG), SIZE=(.50 .20), POSITION=(+2.5 +0), PRESERVERATIO=ON, $
TYPE=SUBHEAD, SIZE=14, STYLE=BOLD, $
TYPE=DATA, COLUMN=FLAG, IMAGE=(FLAG), SIZE=(.12 .12), PRESERVERATIO=ON, $
ENDSTYLE
END
This message has been edited. Last edited by: Hallway,
Hallway
Prod: 8202M1
Test: 8202M4
Repository:
OS:
Outputs:
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015
My original code was missing parenthesis around the IMAGE in the style sheet and it was not kicking off an error until I used some of the code you supplied to simplify everything.
I think this used to work with the error in 7703 but not in 8105, but I don't have an old version to confirm.
version 8202M Reporting Server on Windows Server using DB2 Connect to access data from iseries.