Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed]Problem outputing to Excel
Go
New
Search
Notify
Tools
Reply
  
[Closed]Problem outputing to Excel
 Login/Join
 
Member
posted
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,
 
Posts: 4 | Registered: October 27, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
What version are you on?

Try EXL2K
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Member
posted Hide Post
i AM ON 7703_060611. .

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


Version 7703
Gen 06062011
zOS
 
Posts: 4 | Registered: October 27, 2014Reply With QuoteReport This Post
Master
posted Hide Post
Can you generate excels at all?


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 669 | Location: Veghel, The Netherlands | Registered: February 16, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Have you check if you have a Windows security message that may popup (but behind everything) ?

Reduce every window one by one.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2347 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
Inexplicably it has started working. Don't you just love it when you don't know what fixed a problem.


Version 7703
Gen 06062011
zOS
 
Posts: 4 | Registered: October 27, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed]Problem outputing to Excel

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.