varlena ere: Examples


Overview

Requirements

Examples

How It Works

Design Structure

Tags

Design a Report

Variables

Built-in Arguments

Debugging

Using CSV files

Tricks

Copyright

Reports Home


Examples are the best way to learn to use ere. These examples where run with a script. When many variables are involved, it is a good idea to write a web application which prompts for report variables and runs the report. rerun is an example of that type of application. (But it is not yet generally available)

Here are a couple of very simple report types based on the PostgreSQL 7.3 system catalog. In all of these examples dbname, port, user and schema were passed. This is not shown in the command lines below.
Report XML Report Type Command Line and Output
tablelist.xml Tabular % ere.pl tablelist > tablelist.html
tabbysch.xml Master/Detail % ere.pl tabbysch > tabbysch.html tabbysch.html
tabatt.xml Master/Detail/Detail % ere.pl tabatt rptschema=ere > tabatt.html
    % ere.pl tabatt rptschema=rugby > tabatt_sch.html
    % ere.pl tabatt rptschema=pg_catalog name=pg_namespace > tabatt_schtab.html
matches tabular with alternating color % ere.pl matches > allmatches.html
    % ere.pl matches ttype=Club > clubmatches.html
teamlist master/detail/detail % ere.pl teamlist > allteams.html
    % ere.pl teamlist area="Pac" > pacteams.html


Copyright 2003 through 2009 A. Elein Mustain, Varlena, LLC