Identifying Tags for SUBTOTAL and GRANDTOTAL Lines
The tag is the text that is displayed in the leftmost portion of each SUBTOTAL and GRANDTOTAL row in a report. The tag is used to identify the type of data represented within this row. The text used to generate this tag can be customized by adding an AS name to the SUBTOTAL syntax.
You can define styling for the subtotal and grand total tag separately from the rest of the row. Text attributes available for the tag, including font, color, size, and style, can be used to differentiate and highlight the tags. Additionally, styling can be applied that turns tags into drill-down links.
Styling is supported for text attributes only. Cell or column features, such as borders, background color, or justification are not supported.
This feature is available for PDF, DHTML, PS, HTML, AHTML, PPTX, XLSX, and EXL2K formats.
Style Subtotal and Grand Total Tags
TYPE={SUBTOTAL|GRANDTOTAL}, OBJECT=TAG,
[FONT=font], [SIZE=size], [STYLE=style],
[COLOR={color|RGB({rgb|#hexcolor})],
[drilltype=drillparms], $
where:
Is the name of the font.
Is the point size of the font.
Is the font style, for example bold, italic, or bold+italic.
Is a color name.
Specifies the font color using a mixture of red, green, and blue.
(r g b) is the desired intensity of red, green, and blue, respectively. The values are on a scale of 0 to 255, where 0 is the least intense and 255 is the most intense. Note that using the three color components in equal intensities results in shades of gray.
Is the hexadecimal value for the color. For example, FF0000 is the hexadecimal value for red. The hexadecimal digits can be in uppercase or lowercase and must be preceded by a pound sign (#).
Is any valid drill-down attribute, for example, URL= or FOCEXEC=. For more information about drill-down links, see Linking a Report to Other Resources.
Are valid attribute values for the type of drill down.
Styling SUBTOTAL and GRANDTOTAL Tags
The following request against the GGSALES data source generates subtotal and grand total rows. The tags for the subtotal rows are in italics and are white. The tag for the grand total row has a drill-down link to a URL:
TABLE FILE GGSALES
SUM UNITS/D8C DOLLARS/D12CM BUDUNIT/D8C BUDDOLLARS/D12CM
BY REGION
BY CATEGORY
ON REGION SUBTOTAL
HEADING
"Gotham Grinds Sales Report"
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET DROPBLNKLINE ALL
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=SUBTOTAL, OBJECT=TAG,STYLE=ITALIC,COLOR=WHITE,$
TYPE=GRANDTOTAL, BACKCOLOR='LIGHT GREY',$
TYPE=GRANDTOTAL, OBJECT=TAG,URL='http://www.informationbuilders.com',$
ENDSTYLE
END
The output is:
