Has anyone ever synchronized an AHTML graph to an AHTML report in an HTML page? If so, have you ever run into the problem where the fields are not in the dropdown menu for the X and Y axis on the graph properties? This is the code that I have made for my AHTML report inside the HTML file:

FILEDEF RADORDTOBEG DISK //LEITH/IBI/APPS/HELDFILES/RADORDTOSIG.FTM
TABLE FILE RADORDTOBEG
PRINT *
ON TABLE HOLD AS ORDTOBEG1
END
DEFINE FILE ORDTOBEG1
REALDEP/A15 = IF DEPARTMENT CONTAINS 'EMERGENCY' THEN 'EMERGENCY' ELSE 'OTHER';
ROWORDER/I10 = IF ORDER_TO_BEG EQ '< 1 HOUR' THEN 1
ELSE IF ORDER_TO_BEG EQ '1 TO 2 HOURS' THEN 2
ELSE IF ORDER_TO_BEG EQ '2 TO 3 HOURS' THEN 3
ELSE IF ORDER_TO_BEG EQ '3 TO 4 HOURS' THEN 4
ELSE IF ORDER_TO_BEG EQ '4 TO 5 HOURS' THEN 5
ELSE IF ORDER_TO_BEG EQ '>5 HOURS' THEN 6
ELSE 0 ;
END
TABLE FILE ORDTOBEG1
SUM NUMBER
BY MONTH
BY PROC_CAT
-*BY REALDEP
-*BY ROWORDER NOPRINT
-*BY ORDER_TO_BEG
ON TABLE HOLD AS ORDTOBEG2
END
TABLE FILE ORDTOBEG2
PRINT *
ON TABLE PCHOLD FORMAT AHTML
END

Very simple fex, nothing fancy, yet when I include a graph and synchronize it to this report, the field names do not show up in the dropdown menu for x and y axis on the graph properties.

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

I found the answer. I am posting in case anyone else runs across this problem. You cannot use the PRINT * and expect to see the field names in the X and Y axis dropdown menus. You need to list all of the field names out in the final print statement that contains the ON TABLE PCHOLD FORMAT AHTML