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>
|