Download WDReportCom User Manual

Transcript
AND o.EmployeeID = e.EmployeeID
AND YEAR(o.OrderDate) = 1996
AND MONTH(o.OrderDate) = 04
GROUP BY e.FirstName, e.LastName
ORDER BY 3 DESC
6.3.2 Variable Table Report
Uses VarTableReport method to generate a variable table report. In a variable
table report, the number of rows or columns in the table is unfixed, and it is
variable as the number of the result records. WDReportCom executes a SQL
statement to get data from data source, inserts some blank rows/columns or
copy a range for each record, then fills data into the cells of a table.
Syntax
Report(…)
sqlstatement
Arguments
TYPE = “var”
TABLE = table
FILLORDER = fillorder
CELL= celllist
RANGE = range
IMAGE = fieldlist
RESERVE = reserverecords
PAGEBREAK = pagelength
NODATA = nodataoption
CONNECT = datasource
- 81 -