Using the Compound Layout Report syntax with components and XLSX output, each component is put in a separate XL sheet. Is there a way to have all the components in the same sheet?This message has been edited. Last edited by: FP Mod Chuck,
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 10, 2020, 05:55 PM
Waz
I would have thought that the standard syntax to add a report to the end of another report (Can't remember off the top of my head) would do what you want.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
August 11, 2020, 08:45 AM
wdusbank
use: NOBREAK
in the first report: ON TABLE PCHOLD FORMAT XLSX OPEN NOBREAK END
2nd report: ON TABLE PCHOLD FORMAT XLSX NOBREAK END
last report: ON TABLE PCHOLD FORMAT XLSX CLOSE END
WF 8.2.01M, MF MVS 7.6.5
August 11, 2020, 01:15 PM
Danny-SRL
True, but... this syntax is on the way out... and the newer syntax doesn't seem to offer this functionality. Maybe Chuck has an insight?
About the new syntax: it offers the possibility to refer to an existing procedure, which is a big improvement,in parallel to creating HTML pages where one can have on one page reports, graphs etc...
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 11, 2020, 06:07 PM
Waz
Its been 5 years or so, but I'm sure it can be done, as I think I've done it.
All comes down to the compound layout syntax.
You can attach a report to the end of another report.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
August 12, 2020, 07:40 AM
Danny-SRL
The syntax is probably hiding under a defunct manual...
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 12, 2020, 10:03 AM
jgelona
Better not be on the way out, I have several reports that have been running for years with this syntax.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
August 12, 2020, 12:31 PM
FP Mod Chuck
I'm sorry I don't have any additional insight on this. Compound reports have been around a while and I doubt they would radically change it because of John's concern. Techsupport is your best bet to find out.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats