Entrance Reference Manual

REPORT Syntax

REPORT
       [report_series_type [, ...] ]
    [WITH]
      [TITLE "string"]
      ...
      [NOTE  "string"]
      ...
      [MARGINS n]
      [NO HEADING]
      [NO BLANKLINE]
      [TABBED]
      [FONT font_family  font_style  font_size]
SELECT
   (MySQL select statement body);

The list of report series types, which can be omitted, specifies formats to use for columns in the report.  Each report_series_type can be:

 AUTO | TEXT | SCIENTIFIC | PLAIN | PRINTF (format) | MONEY

"AUTO" is the default and means "make a reasonable choice".


Titles and Notes
You can specify an unlimitted number of titles and notes.  Titles are are left justified and go above the  table.  Notes are also left justified and go below the table.
 
All of the text in a chart is report using a single font, which can be specified using the FONT keyword, which takes the form:

      FONT (family) (style) (size)


"MONOSPACED", "SERIF" and "SANSSERIF" are available on all platforms as font families.  Style can be "BOLD", "ITALIC" or "PLAIN".  Size is the font size in points.

Report settings
"MARGINS" sets the number of blank spaces to leave for the left and right margin.

"NO BLANKLINE" omits the blank line that normally precedes the first line in a report block.

"NO HEADING" omits the column names and underline heading.

"TABBED" specifies that table output should tab delimitted.

Roadmap for 2.0
FIXEDWIDTH          turns off padding and space between columns





MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. 

Copyright (c) Tod Landis 2007 All Rights Reserved                           Modified:  May 30, 2007