There's no iphone app that will do that? ;-) Seriously, you would spool the report to a file and then post-process the file.
Dan On Sun, Sep 26, 2010 at 7:00 AM, Simon Verona <[email protected]>wrote: > Hi all > > This may or may not be a stupid question. > > I have a transaction file, with many thousands of entries in, which should > total zero both on a daily basis (there is a date field in the file) and > overall. > > If I have a problem, then a check is to find which dates do not come back > to zero... > > So, I execute a jQL query like : > > SORT TRANSACTIONS BY DATE BREAK-ON DATE "'VL'" TOTAL 2 (D) > > Which produces a list like : > > 02/07/2010 0.00 > 01/07/2010 0.00 > 30/06/2010 0.00 > 29/06/2010 -585.31 > 28/06/2010 0.00 > 27/06/2010 0.00 > etc etc > > All I want to see though is the dates that don't come to zero.... > > Can this be done using jQL? > > Thanks > Simon > > -- > 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 > -- 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
