Hi all:

I like to show a image in a heading for Excel Button, so that when users are viewing in HTML or PDF they can click on top right corner of the heading and get to Excel format of the report (with parameters already selected)

Also I would like to place a link to this report on another report, so that users can click to get to the new version of the report instead of keep using the Old report.


I have a text in the heading "Export to Excel" and drills down to the report in Excel Format.
I just need to show a button instead of Text..

I get the following error
0 ERROR AT OR NEAR LINE 1305 IN PROCEDURE
(FOC406) THE FIELDNAME IS NOT RECOGNIZED: [img
BYPASSING TO END OF COMMAND

I like to show the image for PDF and HTML versions

here is the code

 
-* Excel Click on PDF Format
-* Below XLGIF paragraph to define Excel button to be presented on results screen
-*   XLGIF/A17 = IF '&WFFMT' NE 'EXL2K'
-*                     THEN 'Export to Excel'
-*                     ELSE ' ';
-*-* Below line used at end of heading line with excel button to stop the white background and revert to Navy.
-*  XLGIF_STOP/A1 = ' ';

-* Show excel button(image) instead of Text
XLGIF/A60='[img src="http://wfserver/basedir/k2abdkk8/excel.jpg';
END
-RUN
-SET &XLGIF='';
-SET &XLGIF ='[img src="http://wfservere/basedir/k2abdkk8/excel.jpg';

-* Heading
-IF &WFFMT NE 'PDF' THEN GOTO SKIPHDX;
-* For text display to excel link
-* "<LNAME<+0><XLGIF"
-* for Excel Button display
"<LNAME<+0><&XLGIF.EVAL"

-* self drill
-*-* Below is PDF self drill to Excel.
TYPE=SUBHEAD,
     BY=GLRE_LOC_ID,LINE=1,
	 ITEM=2,
	 OBJECT=FIELD,
	 SIZE=&FSIZE1.EVAL,
	 STYLE=BOLD,
	 POSITION=8,
	 COLOR='BLACK',
     BORDER-TOP=HEAVY,
     BORDER-BOTTOM=HEAVY,
     BORDER-LEFT=HEAVY,
     BORDER-RIGHT=HEAVY,
     BORDER-TOP-STYLE=SOLID,
     BORDER-BOTTOM-STYLE=SOLID,
     BORDER-LEFT-STYLE=SOLID,
     BORDER-RIGHT-STYLE=SOLID,
     BORDER-TOP-COLOR='WHITE',
     BORDER-BOTTOM-COLOR='WHITE',
     BORDER-LEFT-COLOR='WHITE',
     BORDER-RIGHT-COLOR='WHITE',
     BACKCOLOR='WHITE',
     TARGET='_blank',
	 FOCEXEC=FIMP_MAIN( \
     USERID='&USERID' \
     APP='&APP' \
     REPORT_ID='&REPORT_ID' \
     LOCTYPE='&LOCTYPE' \
     PROC_DATE='&PROC_DATE' \
     PROC_YEAR_NO='&PROC_YEAR_NO' \
	 PROC_MONTH_NO='&PROC_MONTH_NO' \
     RANGE_BEG_DATE='&RANGE_BEG_DATE' \
     RANGE_END_DATE='&RANGE_END_DATE' \
	 REPORT_AUTO_NO='&REPORT_AUTO_NO' \
	 HOLD_RAN='&HOLD_RAN' \
	 LOCPARAM=&LOCPARAM.QUOTEDSTRING \
     WFFMT='EXL2K' \
     ),
$
ENDSTYLE
END

 

This message has been edited. Last edited by: <Kathryn Henning>,

Hi FOCdeveloper

The image should be placed in the stylesheet syntax.

Here is a link that will provide assistance with this:
Embedding a Graphical Image (.GIF) within a WebFOCUS Report

Let us know if this is what your are looking for.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.

Thank You Tamra
The Image does display in the heading as expected.. BUT it is not drillable.. or Clickable ..

If I replace the image lines in the stylesheet code with the text/heading.. It does drill..
I have opened the case three days ago.. have not heard anything so far..

 
TYPE=SUBHEAD,
     BY=GLRE_LOC_ID,
	 IMAGE=app/excel2010_TINY.gif,
     POSITION=(8.500000 0.001000),
     TARGET='_blank',
     FOCEXEC=app/FIMP_MAIN.fex( \
     USERID='&USERID' \
     APP='&APP' \
     REPORT_ID='&REPORT_ID' \
     LOCTYPE='&LOCTYPE' \
     PROC_DATE='&PROC_DATE' \
     PROC_YEAR_NO='&PROC_YEAR_NO' \
	 PROC_MONTH_NO='&PROC_MONTH_NO' \
     RANGE_BEG_DATE='&RANGE_BEG_DATE' \
     RANGE_END_DATE='&RANGE_END_DATE' \
	 REPORT_AUTO_NO='&REPORT_AUTO_NO' \
	 HOLD_RAN='&HOLD_RAN' \
	 LOCPARAM=&LOCPARAM.QUOTEDSTRING \
     WFFMT='EXL2K' \
     ),
$

 

I used the Define to show the image and it now drills using HTML.. but the problem is the PDF version.. For PDF i have placed the image in the Application path..

Using StyleSheet, for PDF it shows the image but DOES NOT click/Drill to fex.. I tried to use the "Define" approach, but WebFocus Server takes forever and finally gives the HTTP 500 error..

If someone has used the Image using a Define for the PDF report and used it to Drill, and can share the define here, would be appreciated

I have tried the following but did not work..

Thanks

 

XLGIF/A256 = IF '&WFFMT' NE 'PDF'
             THEN 
-* for HTML
'<img src="http://servername/ibi_html/images/fimp_excel2010_small.png">'
			 ELSE 
-* for PDF
'IMAGE=IBFS:/ Dev/MRE/DOMAINS/develope/develope.htm/OTHERFILES/app/excel_logo.gif';
-* tried following, did not work
-*			 ELSE 'IMAGE=http://servername/apps/baseapp/fimp_excel2010_small.png';


 

save some agita and
CMD COPY C:\ibi\apps\images\pdf.gif
.. or wherever it is
this command copies it into the current agent directory.
then don't do the define, you don't need it for pdf
just use the stylesheet
IMAGE=pdf.gif
and all the position bits you want.
works like a charm.

Thank you Susannah..

Displaying Image in a PDF is not the issue..

It's to have the Image in PDF drill to a fex is the issue..It must not be supported..

Thanks

Just updating here.. functionality (Clickable Image in PDF) is not supported..

Thanks