Focal Point
[CLOSED] Logo won't display in EXL2K heading

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7797009626

December 06, 2012, 03:47 PM
Tomsweb
[CLOSED] Logo won't display in EXL2K heading
I have coded a report in EXL2K format, and
like my others, I want a corporate logo to display
just above the the heading.

In an HTML report I created a field in a DEFINE to
hold the image in a variable, and then I refernced in
the HEADING TAG. In a PDF report I reference the image
in the style sheet; I must declare the POSITION AND SIZE
attributes in this reference.

I have used the report painter to code and place the same
logo in an EXL2K but when I display the report in EXCEL the
logo does not show.

I have posted the code below:

 
DEFINE FILE MMDB1
TDATE/YYMD = &YYMD;
IDATE/I8YYMD = EDIT(RECDTE);
DYMD/YMD = IDATE;
DYYMD/YYMD = DYMD;
AGEDIF/YYMD = DATEADD(TDATE, 'D', -30);
DIFF/I8 = DATEDIF(DYMD, TDATE, 'D');
END

TABLE FILE MMDB1
PRINT 
     MMDB1.WO.DYMD AS 'RCVD,DATE'
     COMPUTE ADDRESS/A38 = NUMBER || ( ' ' | STREET );
     COMPUTE WDCX/A34 = WDC || ( ' ' | WORKDESC );
BY  HIGHEST MMDB1.WO.DIFF AS '#DAYS,OPEN'
BY  MMDB1.WO.WO
HEADING
" "
"Open Customer Work Orders"
"Orders from Oct 27 2012 to Nov 26 2012"
" "
IF RECORDLIMIT EQ 10
WHERE STATUS EQ 'O';
WHERE DYYMD GE AGEDIF;
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=HEADING,
     FONT='ARIAL',
     COLOR='RED',
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     COLOR='PURPLE',
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     COLOR='RED',
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     COLOR='PURPLE',
$
TYPE=HEADING,
     IMAGE=http://wsscapps:81/ibi_html/wssclogoblack189x53.jpg,
     POSITION=(+1.638889 +0.000000),
$
ENDSTYLE
END



Suggestions anyone? Frowner

Thanks!

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


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
December 06, 2012, 03:57 PM
Waz
Have you thought about my technique I posted about a year ago.

Embedded Images in Excel


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 07, 2012, 10:39 AM
Alex
I've done it using a DEFINE:
 
DEFINE FILE [Your File]
IMGTAG1/A200=
'[IMG]http://www.xyz.com/images/logo.bmp[/IMG]'; 
END 

Then in the Report:

TABLE FILE [Your File]
HEADING
"<IMGTAG1"
"Other Report Heading Elements"
...
...
END



WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF