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://hostnameort/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.

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.

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

RichH,

It works. Thank you very much!