Previous Topic

Next Topic

Book Contents

Book Index

Creating Charts in Batch

With AQT you can create charts in batch / unattended mode. This can be useful for creating regular charts with a script or in an overnight batch process.

To do this:


Example:

--aqt chart,series=(col=Sum_Of_quantity_ordered,title=Total Ordered),labelcol=part_number,header="Status of Orders",layout=order_line.xcf,sql="select part_number, sum(quantity_ordered) as Sum_Of_quantity_ordered from Order_Line group by part_number",dbs=AQTDemo,saveas=order_line_20110525.xcf,exportfile=order_line_20110525.jpg,exportimagesize=(800,600)

If the saveas or exportfile file names are not fully qualified, they will be created in the Queries directory.

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.