
REPORT is a SQL extension provided by Entrance used for making
simple reports.  

REPORT  [TEXT, HTML, TABBED, CSV, STYLE1]
    [AUTO | TEXT | SCIENTIFIC | PLAIN | PRINTF (format) | MONEY] [,...]
  [WITH]
    [TITLE "string"] [,...]
    [NOTE  "string"] [,...]
    [PAD n]
    [MARGINS n]
    [NO HEADING]
    [NO BLANKLINE]
    [TABBED] 
    [FONT font_family  font_style  font_size]
    [PAGENAME "(name)"]
SELECT 
   (MySQL select statement body);

Example:

REPORT
    TITLE "This is my title"
    TITLE "This is also my title"
    TITLE " "
    NOTE  " "
    NOTE "This is your note"
    NOTE "This is also your note"
    NOTE "(You can have as many as you want)"
SELECT
    Year, Jan, Feb from CPI LIMIT 5;


Produces this output:

This is my title
 This is also my title
  
 Year  Jan   Feb    
 ----  ----  ----   
 1913   9.8   9.8   
 1914    10   9.9   
 1915  10.1    10   
 1916  10.4  10.4   
 1917  11.7    12   
  
 This is your note
 This is also your note
 (You can have as many as you want)

URL:  http://dbentrance.com/docs/reportsyntax.html
