I believe that this is not dis-similar to my recent thread about
excluding lines of zero sub-totals in a jQL report.
It would appear that this can only be done by producing a report and
then parsing the result..
Simon
On 27/09/2010 20:04, jlogdup wrote:
Maybe is more clear what I want to do it is like the clause HAVING in
oracle or sql server
SELECT ACCT.NO, SUM(CR.AMT)
FROM ACCOUNTS
GROUP BY ACCT.NO
HAVING SUM(CR.AMT)> 10000.00 ;
i want to do the same with JQL.
Thanks in advance for your help,
On Sep 27, 9:23 am, jlogdup<[email protected]> wrote:
Good Morning ,
I have this JQL
SORT ACCOUNTS BY ACCT.NO BREAK-ON ACCT.NO TOTAL CR.AMT DET-SUPP
I want to print only those accounts whose TOTAL CR.AMT greater than
10000.00, how I can do that ?
Thanks,
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
