[GNC] Report question

[D.]

If you took the report data and pasted it directly into your favorite spreadsheet, you could save the result as CSV, no problem. 

At this point, it might be more useful if you explained more completely what it is you're trying to accomplish. Then people on the list could help you solve the problem, rather than half answer your half-stated question. 

David


-------- Original Message --------
From: Paul Kinzelman <paul at kinzelman.com>
Sent: Sat Feb 26 11:56:27 EST 2022
To: Tommy Trussell <tommy.trussell at gmail.com>
Cc: Gnucash Elist <gnucash-user at gnucash.org>
Subject: Re: [GNC] Report question

Thank you for the detailed instructions.
I found that 'Transaction Report' will do what I want, but then
I can't export to CSV.

I can export to HTML by Export Report
I can 'Export as PDF' but not CSV. That's what I'm missing.
This would be really nice to add.

I can Export Transactions, but that does not export the transactions
of the transaction report which is what I wanted to do.

On 2/25/2022 6:08 PM, Tommy Trussell wrote:
> On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman <paul at kinzelman.com> wrote:
>
>     Do you mean Account Report? But when I go to File | Export, it asks
>     me which accounts again, it doesn't export the actual report.
>
>     When I export the transactions I want, it exports both sides of the
>     transaction, so the column sum is always zero whereas I want the
>     sum of the transactions.
>
>     In other words, each transaction takes two lines, the line I want
>     (the expense of what I bought), and the next line which is the
>     account that paid it (like a charge card).
>
>     How do I get rid of the double-lines on the export?
>
>
> We're apparently not seeing the same thing you are.
>
> Here's a way to get an Account Report for your credit card 
> transactions. (This is using GnuCash 4.9.)
>
> 1) Open the account
>    Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA  
> (yours will differ)
>
> 2) Use Filter By to select the transactions you want [while the 
> register is active]
>    View --> Filter By (choose parameters such as date, number of days, 
> reconciled, etc.)
>
> 3) Open Account Report [while the filtered register is active]
>     Reports --> Account Report
>
> 4) Adjust the options on the report
>    Edit --> Report Options
>    (here you can adjust specific columns, single or double amount 
> columns, totals or running total, style, report name, etc.)
>
> 5) Export the report
>     You can copy what's on your screen and paste it into a word 
> processor or spreadsheet
>     OR
>     File --> Export --> Export Report  (give it a name -- it will save 
> an .html file you can open with a web browser or a spreadsheet program)
>
>     -----
>     Please remember to CC this list on all your replies.
>     You can do this by using Reply-To-List or Reply-All.
>
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.