Controlling Display of an ACROSS Title for a Single Field

How to:

By default, when there is only one field displayed for an ACROSS sort group, no column title displays above that field. Using the SET ACRSVRBTITL command, you can control the display of ACROSS column titles when there is one displayed field for an ACROSS group. The field count that determines whether the ACROSS title displays is affected by certain components in the report request, such as calculated fields or fields in headings.

The output is unaffected by SET commands that adjust underlines with titles, adjust the space between columns, or eliminate unpopulated ACROSS columns on the page. The size of the title and the number of lines it occupies also do not affect the output.

Top of page
x
Syntax: How to Control Display of an ACROSS Title for a Single Field
SET ACRSVRBTITL = {OFF|ON|HIDEONE} 
ON TABLE SET ACRSVRBTITL {OFF|ON|HIDEONE}

where:

OFF

Suppresses the title when there is only one display field.

ON

Displays the title when there is only one display field.

HIDEONE

Suppresses the title when there is only one display field, but the request contains one or more of the following components:

  • Fields in a heading or footing.
  • Fields whose display is suppressed with the NOPRINT phrase.
  • Reformatted fields (which are normally counted twice).
  • A COMPUTE command referencing multiple fields.
Example: Displaying or Suppressing a Single ACROSS Column Title

The following request against the GGSALES data source has one display field, DOLLARS. The ACRSVRBTITL parameter is OFF (the default):

SET ACRSVRBTITL=OFF
TABLE FILE GGSALES
SUM DOLLARS AS Sales
ACROSS REGION
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END

On the output, there is no column title that indicates what the number in each column represents:

Region                                              
Midwest      Northeast    Southeast    West         
----------------------------------------------------
11514345     11494543     11781285     11674908

The following is the same request with ACRSVRBTITL=ON:

SET ACRSVRBTITL=ON
TABLE FILE GGSALES
SUM DOLLARS AS Sales
ACROSS REGION
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END

On the output, the title Sales appears above each field value in the ACROSS group:

Region                                              
Midwest      Northeast    Southeast    West         
   Sales        Sales        Sales        Sales     
----------------------------------------------------
11514345     11494543     11781285     11674908
Example: Hiding an ACROSS Title With HIDEONE

The following request against the GGSALES data source has a display field in the heading:

SET ACRSVRBTITL=OFF         
TABLE FILE GGSALES          
HEADING               
"Sales Report for <CATEGORY with ACRSVRBTITL=OFF"
" "                         
SUM DOLLARS AS Sales        
BY CATEGORY                 
ACROSS REGION               
WHERE CATEGORY EQ 'Food'    
ON TABLE SET PAGE NOPAGE    
END

With the default setting ACRSVRBTITL=OFF, the field in the heading counts and the ACROSS title Sales is not suppressed:

Sales Report for Food with ACRSVRBTITL=OFF                   
                                                             
             Region                                          
             Midwest     Northeast   Southeast   West        
Category        Sales       Sales       Sales       Sales    
-------------------------------------------------------------
Food          4404483     4445197     4308731     4204333

Changing ACRSVRBTITL to ON produces the same report:

Sales Report for Food with ACRSVRBTITL=ON                    
                                                             
             Region                                          
             Midwest     Northeast   Southeast   West        
Category        Sales       Sales       Sales       Sales    
-------------------------------------------------------------
Food          4404483     4445197     4308731     4204333

Changing ACRSVRBTITL to HIDEONE suppresses the ACROSS title Sales:

Sales Report for Food with ACRSVRBTITL=HIDEONE               
                                                             
             Region                                          
             Midwest     Northeast   Southeast   West        
Category                                                     
-------------------------------------------------------------
Food          4404483     4445197     4308731     4204333
WebFOCUS