REPORT Syntax

Overview

REPORT is a SQL extension provided by Entrance for generating reports. Scripts containing REPORT can be run from the Entrance desktop application. REPORT is not supported by EntranceServlet.

A Simple Example

REPORT
    TITLE "This is a title"
    TITLE "So is this"
    TITLE " "
SELECT
    Year, Jan, Feb from CPI LIMIT 5;

Produces this output:

 This is a title
 So is this 

 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

REPORT Syntax

REPORT  [TEXT, HTML, TABBED, CSV, RAWHTML, RAWTEXT]
    [AUTO | TEXT | SCIENTIFIC | PLAIN | DECIMAL (format) | MONEY] [,...]
  [WITH]
    [STYLE ""]
    [ID    "string"]
    [HEAD  "..."] 

    [TITLE "string"] [,...]
    [NOTE  "string"] [,...]
    [PAD n]
    [MARGINS n]
    [NO HEADING]
    [NO BLANKLINE]
    [TABBED] 
    [FONT font_family  font_style  font_size]
    [FOREGROUND (color)]
    [BACKROUND (color)]
    [PAGENAME "(name)"]
SELECT 
   (MySQL select statement body);