If only OpenRPT supported variables ...
Hi.
Developing a custom report showing all open orders and the details of each.
I have my query successfully showing everything I need - group header for header items, detail band for items. I would like to use the group footer to show the items subtotal, then the freight and misc from the cohead record, and add all together to get an order total.
I would use the standard sales order template, except that the footer query uses the parameter of the single sales order to print. Since I am printing details on all open orders, I can't use that footer query.
Ideally, I would have the cohead_freight and cohead_misc fields on the detail query, then simply add them to the subtotal amount in the footer. There's the problem, it doesn't look like variables are supported in OpenRPT.
I can post the report template if necessary,
Thanks.

