Focal Point
[CLOSED] Multiple Excel Worksheets with FML Not Working after Upgrade

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2457068495

December 06, 2010, 05:16 AM
jammer
[CLOSED] Multiple Excel Worksheets with FML Not Working after Upgrade
I just upgraded to 7.701. I am no longer getting multiple excel worksheets when I
include the 3 lines of FML Code.

I can change the routine to used "TOC" instead but I want to know why this is no longer working.

-*____________________________________________________________________________________
FILEDEF TGCNSYS2 DISK baseapp/TGCNSYS2.FTM
FILEDEF GCNGL DISK GCN_METADATA/GCNGL.FTM
-SET &IDX = 1;
-REPEAT LAB2 WHILE &IDX LE 2;
-SET &OUTPUT = IF &IDX EQ 1 THEN 'EXL2K OPEN' ELSE 'EXL2K CLOSE' ;
JOIN CLEAR *
JOIN
GCNGL.GCNGL.GL_ACCOUNT IN GCNGL TO MULTIPLE TGCNSYS2.TGCNSYS2.GL_ACCOUNT IN TGCNSYS2
AS J0
END
TABLE FILE GCNGL
SUM
AMOUNT
ACROSS LOB_GROUP
-***************************************************************
-* FML CODE
FOR
GL_ACCOUNT
'2000' GET CHILDREN ALL
-****************************************************************
ON TABLE PCHOLD FORMAT &OUTPUT
END
-SET &IDX = &IDX + 1;
-LAB2;
-*____________________________________________________________________________________

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


Webfocus 7.6.4
Windows 2003 Server, SQL Server 2005
Excel, HTML , JavaScript ,and PDF.
Reportcaster, BID, Tomcat
December 06, 2010, 05:21 AM
Tony A
Jammer,

This is the sort of question that would be best raised direct to IB Technical Support via Info Response and not the Forum.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
December 06, 2010, 11:38 AM
jammer
Yes - I will open a case with Tech support.

As far as the code is concerned is there anything wrong or unusual?


Webfocus 7.6.4
Windows 2003 Server, SQL Server 2005
Excel, HTML , JavaScript ,and PDF.
Reportcaster, BID, Tomcat