Hello, I am developing a compound XLSX report. I need to set a COLSPAN or control a column size to align columns from both reports.

Any suggestions?

I reproduced it using CAR.

  
-* File: IBFS:/localhost/EDA/EDASERVE/APPPATH/vesir21815/dev/Procedure2.fex Created by WebFOCUS AppStudio
TABLE FILE CAR

SUM SALES
BY COUNTRY   NOPRINT
BY MODEL
BY CAR
ON COUNTRY SUBTOTAL
HEADING CENTER
"Example of COLSPAN"
ON TABLE COLUMN-TOTAL  RECOMPUTE
ON TABLE PCHOLD FORMAT XLSX OPEN NOBREAK AS WF_TEST
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET STYLE *

TYPE=REPORT,
TITLETEXT='Summary',
SIZE=7,
PAGESIZE=A3,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
GRID=OFF,
-*	 BORDER-BOTTOM=LIGHT,
-*	 BORDER-LEFT=LIGHT,
-*	 BORDER-RIGHT=LIGHT,
-*	 BORDER-TOP=LIGHT,
$


END



TABLE FILE CAR
SUM
SALES
BY COUNTRY
BY MODEL 
BY CAR
ON TABLE COLUMN-TOTAL  RECOMPUTE
ON TABLE PCHOLD FORMAT XLSX CLOSE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET STYLE *

TYPE=REPORT,
TITLETEXT='Summary',
SIZE=7,
PAGESIZE=A3,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
GRID=OFF,
-*	 BORDER-BOTTOM=LIGHT,
-*	 BORDER-LEFT=LIGHT,
-*	 BORDER-RIGHT=LIGHT,
-*	 BORDER-TOP=LIGHT,
$

END

This message has been edited. Last edited by: Ricardo Augusto,

I'm not sure what you're looking for. One report has three columns, the other has four - you could add a dummy column in the first report and have the same number of columns in both reports.

HEADALIGN only applies to heading and footing elements in a report and subsequently, you cannot use COLSPAN on a data column.

Meanwhile, search for 'COLSPAN DATA COLUMN' and this is probably one of the few hits that might be helpful:

http://forums.informationbuild...71057331/m/556103394

Thanks Francis, I added some ' ' to align columsn.

SOLVED

This message has been edited. Last edited by: Ricardo Augusto,