Focal Point
[CLOSED] Excel: Compound Layout Report

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

August 10, 2020, 06:47 AM
Danny-SRL
[CLOSED] Excel: Compound Layout Report
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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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