Actian X 11.2 | report Examples

Character-based Querying and Reporting Tools User Guide > Character-based Querying and Reporting Tools User Guide > System Commands for the Forms-based Tools > report Command--Run a Report > report Examples

Was this helpful?

report Examples

1. Run a default report based on the vendor table in the purchasing database, using a default format and redefining the page width, and send the output to the named printer:

report purchasing vendor -m -180 -olaser2

2. Run the report contained in the source file, po_rep.rw, against the purchasing database and store the results in the po_sum_out file:

report purchasing -ipo_rep.rw -fpo_sum.out

3. Run a default report in column format on the clients table owned by mktgmgr in the sales database and eliminate duplicate rows:

report sales mktgmgr.clients -mcolumn -6

4. Run the report named recpay against the accounting database and pass in the value of the variable, title: