Re: Query Manager Totals Only

From a quick test (at V5R3) it doesn't look like running a *QRYDFN object with STRQM does a very good job of running a totals only report. (just lost my connection so can't test any further...)

Or do have a *QMQRY object that was created from a *QRYDFN? If so, and
the *QRYDFN has sum functions, I'm not sure that it will convert very
well to a *QMQRY. My recommendation would be to use STRQM to create the
report you want. You can do it with an interface very similar to
Query/400, but there are differences when you come to formatting the
report. Depending on the complexity of the report, I'd probably use
STRQM and change your existing *QMQRY to SQL and use SUM(field) to get your totals, then tweak the SQL, then do F13 to work with the report layout. But if you are not comfortable with SQL and/or STRQM this may be a bit difficult.

Sam

On 2/27/2015 4:56 PM, Gary Thompson wrote:

Easy to do in a *QRYDFN but I'm not seeing how to set a *QMQRY to
print only totals ?

We have a local command that converts *QRYDFN to *QMQRY which I used
to create a *QMQRY version that I can pass parameters to so users can
create a totals only report, but have yet found how to do that for
the Query Manager report.

---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com