If I run the following code, I get an HTML output to my browser, but if I change the format to Exl07 I get nothing, no erros, just blank screen.

JOIN
INNER FILE DSSOT001_T_CONT AT DSSOT001_T_CONT.DSSOT001.CONTRACT_ID TO MULTIPLE
FILE DSSOT008_T_CONT_CRIT_DT AT DSSOT008_T_CONT_CRIT_DT.DSSOT008.CONTRACT_ID
TAG J1 AS J1
WHERE ( DSSOT001_T_CONT.DSSOT001.CONTRACT_ID EQ J1.DSSOT008.CONTRACT_ID ) AND ( J1.DSSOT008.CRITICAL_DATE_TYPE EQ 'EXEC' );
END
JOIN
DSSOT001_T_CONT.DSSOT001.CURRENT_VENDOR_ID IN DSSOT001_T_CONT TO UNIQUE
DSSOT041_T_VEND.DSSOT041.VENDOR_ID IN DSSOT041_T_VEND TAG J2 AS J2
END
TABLE FILE DSSOT001_T_CONT
PRINT
J2.DSSOT041.VENDOR_ID AS 'VENDOR_ID'
J2.DSSOT041.VENDOR_FULL_NAME AS 'VENDOR_FULL_NAME'
DSSOT001_T_CONT.DSSOT001.DISTRICT AS 'DISTRICT'
DSSOT001_T_CONT.DSSOT001.COST_CENTER AS 'COST_CENTER'
J1.DSSOT008.CRITICAL_DATE AS 'CRITICAL_DATE'
DSSOT001_T_CONT.DSSOT001.ROADWAY_CONTRACT_TYPE AS 'ROADWAY_CONTRACT_TYPE'
DSSOT001_T_CONT.DSSOT001.AWD_CONTRACT_AMT AS 'AWD_CONTRACT_AMT'
DSSOT001_T_CONT.DSSOT001.NET_CHANGE_ORDER_AMT AS 'NET_CHANGE_ORDER_AMT'
COMPUTE current_cont_amout/D12.2 = DSSOT001_T_CONT.DSSOT001.AWD_CONTRACT_AMT + DSSOT001_T_CONT.DSSOT001.NET_CHANGE_ORDER_AMT; AS 'Current,Contract Amount'
DSSOT001_T_CONT.DSSOT001.CONTRACT_DESCRIPTION AS 'CONTRACT_DESCRIPTION'
BY DSSOT001_T_CONT.DSSOT001.CONTRACT_ID AS 'CONTRACT_ID'
WHERE (( J1.DSSOT008.CRITICAL_DATE_TYPE EQ 'EXEC' ) AND ( DSSOT001_T_CONT.DSSOT001.ROADWAY_CONTRACT_TYPE LIKE 'M%' ) AND ( DSSOT001_T_CONT.DSSOT001.CONTRACT_STATUS_TYPE EQ 'ACTV' )) AND (( DSSOT001_T_CONT.DSSOT001.CONTRACT_ID EQ J1.DSSOT008.CONTRACT_ID ) OR ( J1.DSSOT008.CRITICAL_DATE_TYPE EQ 'WKCM' ) AND ( J1.DSSOT008.CRITICAL_DATE EQ 0 ));
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
END

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

What version are you on?

Try EXL2K

i AM ON 7703_060611. .

I have tried EXL95, EXL97, EXL2k and EXL07. I got nothing from any of them.

Can you generate excels at all?

Have you check if you have a Windows security message that may popup (but behind everything) ?

Reduce every window one by one.

Inexplicably it has started working. Don't you just love it when you don't know what fixed a problem.