Re: Query Manager Totals Only

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

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