Focal Point
[CLOSED]Compound Excel report not displaying all reports

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

November 08, 2017, 10:13 AM
Nova27
[CLOSED]Compound Excel report not displaying all reports
Hello,

I am trying to display 4 to 5 reports, one after another, on an Excel spreadsheet.
I have TABLE FILE statements for each of these reports and the format I am using is EXL07.

When I use EXL07 like below - it only displays first 2 reports and does not display the others:
TABLE FILE ABC
PRINT
....
.....
ON TABLE PCHOLD FORMAT EXL07 OPEN NOBREAK
END

TABLE FILE ABC2
PRINT
....
......
ON TABLE PCHOLD FORMAT EXL07 NOBREAK
END

TABLE FILE ABC3
PRINT
....
......
ON TABLE PCHOLD FORMAT EXL07 NOBREAK
END

TABLE FILE ABC4
PRINT
....
......
ON TABLE PCHOLD FORMAT EXL07 CLOSE
END


But when in the same above code if I use EXL2K in place of EXL07, it works - all reports display one after the other.

Is there a known issue with EXL07 compound reports? Please advise.

P.S.: I am using WF 7.7.03

Thanks!

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


WF 7.7.03, Win 7
November 08, 2017, 10:29 AM
Francis Mariani
"As of WebFOCUS Release 7.7.03, format EXL07 and format XLSX are synonyms and can be used interchangeably".

Please read this: WebFOCUS XLSX/EXL07 Format Supported Features Release Roadmap. Compound EXL07 reports are not supported in v7.7.03. Their first appearance is in v7.7.05.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 08, 2017, 10:32 AM
Francis Mariani



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 08, 2017, 11:03 AM
Nova27
Thanks a lot for the information! This helps!


WF 7.7.03, Win 7