Hi,

Have a requirement to load the graph image in the excel starts before the Tabular report (i.e., First 6 Columns are Image and then Tabular report)

I tired to Hold the Graph in GIF file - > ON GRAPH HOLD AS LEAD FORMAT GIF

and then How to use this HOLD file in the Define field, What is the URL to get this image in WF8

In 7x I used as
IMAGE1/A200= '';

But this is not help me in WF8, anyone know how to use IMG SRC in WF8 version ('')

Thanks,
Dev

This message has been edited. Last edited by: <Emily McAllister>,

you might want to create a CAR demo of what was working and what your trying to do. I'm little confused on your goal.

below is the sample what am trying

-SET &ECHO = ALL;
DEFINE FILE CAR
SUM_VAL1/D12 = DEALER_COST/10;
SUM_VAL2/D12 = DEALER_COST/1.5 * 25;
SUM_VAL3/D12 = DEALER_COST;
END
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM SUM_VAL1 AS '' SUM_VAL2 AS '' SUM_VAL3 AS ''
BY COUNTRY AS ''
BY CAR NOPRINT
ON GRAPH HOLD AS LEAD FORMAT GIF
-*ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getO1MajorGrid(),false);
setFillColor(getFrame(),new Color(192,192,192));
setTransparentBorderColor(getChartBackground(),false);
setSmoothLines(true);
setLegendPosition(2);
setLegendOrient(0);
setBorderColor(getLegendArea(),new Color(0,0,0));
setTextString(getO1Title(),"");
setFontName(getO1Label(),"ARIAL");
setFontSizeAbsolute(getO1Label(),true);
setAutofit(getO1Label(),false);
setFontSizeInPoints(getO1Label(),10);
setPlaceResize(getO1Label(),0);
setFontName(getY1Label(),"ARIAL");
setTextFormatPreset(getY1Label(),-2);
setGridStyle(getY1MajorGrid(),2);
setAltFmtFrameNumColors(getY1AltFmtFrame(),5);
setTransparentBorderColor(getLegendArea(),false);
*END
ENDSTYLE
END
-RUN
-*IA_GRAPH_FINISH
DEFINE FILE CAR
SPACE/A5='';
IMAGE1/A200= '';
END
TABLE FILE CAR
BY CAR NOPRINT
HEADING
“IMAGE1”
END
-EXIT

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

Please use the code tags for posting code.

When editing click on the

</>

APPROOT is now hidden with WF8.

You should put your images in the repository, and then reference them with something like this:

<img src="/ibi_apps/run.bip?BIP_REQUEST_TYPE=BIP_RUN&|BIP_folder=IBFS:/WFC/Repository/{location}&|BIP_item=' || {image name} || '">

Or you can put a folder called images in your \WebFOCUS\ibi\WebFOCUS81\ibi_html folder. Then access it directly using yourDom:8080/ibi_html/yourFolder/Yourfiles.jpg

Thanks Waz

I changed few thing and tried below URL its working in HTML but not in Excel format, Is there we need to change any server settings or in the Code level

img src=http://wwwdev.webfocus8.TEST.com/ibi_apps/run.bip?BIP_REQUEST_TYPE=BIP_RUN&|BIP_folder=IBFS:/WFC/Repository/EMPLOy1/Image&|BIP_item=graph_test.png

How to HOLD the image file in the Content folder and how to use the same!

What format Excel are you using ?

for PDF and Excel it should be different

Am using Excel Waz

quote:

What format Excel are you using ?

What output format are you using ?

This should be detailed in the documentation

XLSX

You should just be able to specify the location in the stylesheet with XLSX format.

IMAGE={location}, $

location is IBFS.... or if the image is on the WebFOCUS server, and its in the path, then the name.

Thanks to all

Its working. below is the code. But this image is storing in the Data server.
Am trying to HOLD this image in the content and have to retrieve. Please share if anyone know!

SET GRAPHSERVURL=''
FILEDEF CHART DISK chart.gif
END

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
ON TABLE HOLD AS CHART FORMAT GIF
ON TABLE SET STYLE *
ENDSTYLE
END

DEFINE FILE GGSALES
SHOWCAT/A100='chart.gif';
END
TABLE FILE GGSALES
SUM DOLLARS UNITS BUDDOLLARS BUDUNITS SHOWCAT NOPRINT BY REGION BY ST BY CATEGORY BY PRODUCT
ON TABLE SET BYDISPLAY ON
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET STYLE *
FONT=ARIAL,SIZE=12,XLSXPAGESETS=ON,TOPMARGIN=1,BOTTOMMARGIN=1,ORIENTATION=LANDSCAPE,PAGESIZE=LETTER,$
TYPE=TITLE, COLOR=WHITE, BACKCOLOR=GREY,$
TYPE=DATA,COLUMN=DOLLARS,IMAGE=(SHOWCAT),POSITION=(+0.000000 +0.000000),SIZE=(.5 .5),$
END

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

Can't you just replace IMAGE=(SHOWCAT) with IMAGE=file.gif and as along as file.gif is in the path it should pick it up.

Yes it will work, Why we need to assign the image file name in separate separate place, am just kept as in one place and am reusing.

The TYPE=DATA,COLUMN=SHOWCAT,IMAGE=(SHOWCAT),SIZE(n n),$ syntax is how you would present the image into the output when the contents of the SHOWCAT field is a BLOB.

T