excel graph with hold file problem

Hi,

I am running an issue while I was trying to run the graph in excel format using a hold file
My sample as below:
FILEDEF GRAF1 DISK //home/eda/ibi/apps/ibisamp/GRAF1.PNG

TABLE FILE CAR
PRINT *
ON TABLE HOLD AS HOLD1
END

SET GRAPHSERVURL=http://hostname

ort/ibi_apps/IBIGraphServlet
GRAPH FILE HOLD1
SUM SALES
BY COUNTRY
ON TABLE HOLD AS GRAF1 FORMAT PNG
END
DEFINE FILE HOLD1
IMG1/A60 WITH HOLD1='

';
ENDIMG1/A6 WITH HOLD1='';
END
TABLE FILE HOLD1
FOOTING CENTER
"ON TABLE PCHOLD FORMAT EXL2K
END

I got the error message as:
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: HOLD1
It doesn't like the define field:
IMG1/A60 WITH HOLD1='

';
ENDIMG1/A6 WITH HOLD1='';

If I don't use the HOLD1 file, instead use the CAR file and just put:
DEFINE FILE CAR
IMG1/A60 WITH CAR='

';
ENDIMG1/A6 WITH CAR='';
it works fine.

Anyone knows how to fix this problem as I do have to use hold file for my report.

Posts: 28 | Registered: October 26, 2006

Leah

Virtuoso

posted

Hide Post

You are trying to use the name of a file in your define which is a no-no. And saving a file as a graph image does not give you anything to table file against unless there is something of which I not aware. Of course I haven't put images in an excel file, so is there other information you are processing as well in the real fex.

Leah

Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004

Ignored post by Leah posted

Show Post

RichH

Platinum Member

posted

Hide Post

HOLD1 is the FILE name, Try using a Fieldname, like E01. See if that gets you past the FOC003

WebFOCUS 8202 Win 2012
Test - WebFOCUS 8203 on Win 2012

Posts: 173 | Registered: November 16, 2005

Ignored post by RichH posted