The Robertson Team


 

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
 
  Programmers' Tools >  The Free Stuff >  ReportMonger >  Usage
 

Usage

ReportMonger is a relatively simple single-template system.  You specify the following parameters directly inside of it:

DataSource

The datasource name.

TableName

The name of the table you are querying.

FieldNames

A comma-separated list consisting of the table fieldnames in your output, in left-to-right order of display in your report.

WhereClause

The SQL Where clause of your query.

SortColumn

The sorted column in the report. Users can change the sorted column.

SortType

Ascending or Descending sort order.  Users can change the sort type.

BorderBGColor

The color of the border area surrounding the report body on the left, top and bottom sides (see demo).

BorderFGColor

The font color in the border area (applied via a SPAN command along with a style).

PageBGColor

The page background color.

NavBGColor

The background color of the navigation area.

PreDefOutput

A comma-separated list - the number of values are unlimited - that define the predefined output count (maxrows) of each page.

ColTitles

A comma-separated list of the column titles for each output field.  May optionally include html.

PageTitle

The HTML and visible page title for the report.

<cfscript>
variables.TableName="myTable";
variables.DataSource="myDSN";
variables.FieldNames="ChargeDate,MonthBilled,Transaction,Charges,ChgClass";
variables.WhereClause="0=0";
variables.SortColumn="ChargeDate";
variables.SortType="DESC";
variables.ColumnTitles="Chg<br>Date,Mo.<br>Billed,Item<br>Detail,Chg<br>Amt,Chg<br>Class";
variables.PreDefOutput="25,50,100,200";
variables.BorderBGColor="##dc143c";
variables.BorderFGColor="##ffffff";
variables.PageBGColor="##ffffff";
variables.NavBGColor="##e9e9e9";
variables.PageTitle="Report";
</cfscript>

 


The Robertson Team, TheKing@mysecretbase.com
1.559.360.1717 


HostMySite.com is a leader in ColdFusion web hosting and managed dedicated servers.