Reports: Sorting Cash flow Report

Sun Jan 15 12:38:19 EST 2017

      You right, I was not clear enough.

   I'm using Libreoffice. I was referring to the number of manipulations
   to get a new report using a spreadsheet: copy/paste, removing the
   currency code to sort numbers, sorting the 2 blocks one by one.

   This is better than nothing, but would be great to have it directly in
   Gnucash.

   I've copied the Cash-flow report in ~/.gnucash, tried to replace the
   sorting line (line 227):

             ;; (set! money-out-accounts (sort money-out-accounts
   account-full-name<?))
             (set! money-out-accounts (sort money-out-accounts
   s-report-value<?))

   But this does not work.

   I got the following the report page: "Report Error/
   An error occurred while running the report."
   And in the logs:  "ERROR: In procedure module-lookup: Unbound variable:
   s-report-value<? "

   It seems I'm not using the correct variable. May be someone could help
   identifying the correct variable?

   On 01/14/2017 05:34 AM, David T. wrote:

   I honestly don’t understand your reply.

   Are you having trouble saving? The “Export” button on the toolbar will
   initiate this process. I find that I need to add an html ending on the
   filename

   Are you having trouble opening this in your spreadsheet? I have Excel,
   and I can simply open the html in Excel, and the file parses in
   directly. If your spreadsheet doesn’t allow this, then you can try
   highlighting the data in the GnuCash report window (Select All) and
   pasting into an empty worksheet. Both these methods work for me.

   Once the data is in your spreadsheet, the possibilities are limited
   only by your spreadsheet program.

   Or is there some other box in which you are trapped?

   David

   On Jan 14, 2017, at 1:00 AM, Didier Dubois <[1]didier at didier-dubois.ch>
   wrote:

   Thanks David.

   Sadly this tricks does not work out of the box.

   I'm considering another option...
   On 01/13/2017 04:10 AM, David wrote:

   I would simply save the basic report as html and open the html in a
   spreadsheet. Scheme and I don't get along.

   David
     __________________________________________________________________

   From: [2]dev at didier-dubois.ch
   Sent: Thu Jan 12 22:48:04 GMT+05:00 2017
   To: "David T." [3]<sunfish62 at yahoo.com>, [4]dev at didier-dubois.ch
   Cc: [5]gnucash-user at gnucash.org
   Subject: Re: Reports: Sorting Cash flow Report

   Thanks.

   Is there anyone who could drive me with the report code?

   I managed to create a custom report using cash-flow.scm but I'm lost in
   sorting code with Guile. Could anyone help?

   Alternatively, is there a way to export as CSV to that I could create
   my own report?

   Thanks.

   On 01/08/2017 09:33 AM, David T. wrote:

Unfortunately not. You would have to rewrite the report code to allow that, or f
ind a different report that you could tweak to achieve your desired results. Off
hand, I don’t know what that report would be, but others might have suggestions.

David

On Jan 7, 2017, at 6:53 PM, [6]dev at didier-dubois.ch wrote:

Dear All,

Is there a way to sort the Cash Flow report by "amount"?
It would be helpful in order to quickly see where money comes form and where goe
s to!

Cheers,
Didier.
_______________________________________________
gnucash-user mailing list
[7]gnucash-user at gnucash.org
[8]https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

   --
   Didier Dubois
   Tel: 076/432-54-64
   [9]View Didier Dubois's profile on LinkedIn

   --
   Didier Dubois
   Tel: 076/432-54-64
   [10]<btn_liprofile_blue_80x15.png>

   --
   Didier Dubois
   Tel: 076/432-54-64
   [11]View Didier Dubois's profile on LinkedIn

References

   Visible links
   1. mailto:didier at didier-dubois.ch
   2. mailto:dev at didier-dubois.ch
   3. mailto:sunfish62 at yahoo.com
   4. mailto:dev at didier-dubois.ch
   5. mailto:gnucash-user at gnucash.org
   6. mailto:dev at didier-dubois.ch
   7. mailto:gnucash-user at gnucash.org
   8. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   9. https://ch.linkedin.com/pub/didier-dubois/1/7a2/73
  10. https://ch.linkedin.com/pub/didier-dubois/1/7a2/73
  11. https://ch.linkedin.com/pub/didier-dubois/1/7a2/73

   Hidden links:
  13. mailto:dev at didier-dubois.ch
  14. mailto:sunfish62 at yahoo.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: btn_liprofile_blue_80x15.png
Type: image/png
Size: 426 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170115/e108f166/attachment.png>