Reports: Sorting Cash flow Report

[David T.]

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 <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: dev at didier-dubois.ch <mailto:dev at didier-dubois.ch>
>> Sent: Thu Jan 12 22:48:04 GMT+05:00 2017
>> To: "David T." <sunfish62 at yahoo.com> <mailto:sunfish62 at yahoo.com>, dev at didier-dubois.ch <mailto:dev at didier-dubois.ch>
>> Cc: gnucash-user at gnucash.org <mailto: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 find a different report that you could tweak to achieve your desired results. Offhand, I don’t know what that report would be, but others might have suggestions.
>>> 
>>> David
>>> 
>>>> On Jan 7, 2017, at 6:53 PM, dev at didier-dubois.ch <mailto: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 goes to!
>>>> 
>>>> Cheers,
>>>> Didier.
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user <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
>>   <https://ch.linkedin.com/pub/didier-dubois/1/7a2/73>
> -- 
> Didier Dubois
> Tel: 076/432-54-64
> <btn_liprofile_blue_80x15.png> <https://ch.linkedin.com/pub/didier-dubois/1/7a2/73>