x

The StyleSheet options ORIENTATION=LANDSCAPE and BORDER=ON are now supported for EXL2K report output.

The BORDER attribute supports the same options as currently available for FORMAT PDF except for border options available in Adobe PDF but not available in Microsoft Excel:

• Border line width. Excel 2003 does not have an option for specifying a number to precisely set the border line width (thickness) in points.
• Borders with grooves and ridges. Excel 2003 does not have an option for specifying grooved or ridged borders.

Note: FORMAT EXL2K does not support the GRID=ON parameter.

Top of page

Example: Styling the Orientation and Border for an EXL2K Report

The following report against the EMPLOYEE data source makes the orientation landscape and specifies dotted red borders:

TABLE FILE EMPLOYEE                                       
PRINT ACCTNUMBER AS 'Account Number' AND COMPUTE          
LAST3_ACCT/I3L = IMOD(ACCTNUMBER, 1000, LAST3_ACCT);      
BY LAST_NAME AS 'Last Name' BY FIRST_NAME AS 'First Name' 
WHERE (ACCTNUMBER NE 000000000) AND (DEPARTMENT EQ 'MIS');
ON TABLE HOLD FORMAT EXL2K FORMULA                        
ON TABLE SET STYLE *                                      
TYPE=REPORT, ORIENTATION=LANDSCAPE,BORDER=ON,             
BORDER-COLOR=RED,BORDER-STYLE=DOTTED,$                    
TYPE=TITLE, SIZE=12, STYLE=BOLD, $                        
END                                                       

The output is: