Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Column size or COLSPAN on XLSX report?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Column size or COLSPAN on XLSX report?
 Login/Join
 
Guru
posted
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,


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
HEADALIGN only applies to heading and footing elements in a report and subsequently, you cannot use COLSPAN on a data column.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Thanks Francis, I added some ' ' to align columsn.

SOLVED

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


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Column size or COLSPAN on XLSX report?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.