Page 1 of 1
My Gifts
Posted: Sat Nov 08, 2014 3:53 pm
by Nikolay
- gifts_sample.png (15.17 KiB) Viewed 7628 times
-------------------------------------------
Re: My Gifts
Posted: Sun Nov 09, 2014 12:35 pm
by Nikolay
Updated report with currency formating and difference between deposits and withdrawals and columns sorting.
Re: My Gifts
Posted: Wed Apr 01, 2015 1:08 pm
by dca_sonic
Hello Nikolay.
Your reports are very useful. Thanks a lot.
But, in my situation, today for example (April, 1st), I would like to view all April, 2014 deposits and expenses from account that I chose, and the report show me only April 30th 2014, deposits and expenses.
How change it?
Thank you.
Daniel
Re: My Gifts
Posted: Wed Apr 01, 2015 1:46 pm
by Nikolay
Hi Daniel,
Try to change SQL line 14
Code: Select all
where (date('now', 'start of month','-11 month','localtime') <= c.transdate
to
Code: Select all
where (date('now', 'start of month','-12 month','localtime') <= c.transdate
Re: My Gifts
Posted: Wed Apr 01, 2015 2:02 pm
by dca_sonic
Thanks for your reply Nikolay.
I made the change, but the report shows me March, 31th 2014 now. And how I didn't do any deposit or expense on that day, the report shows me $0.00
It helped a little, but is possible don't show March? Just the interval of completed 12 Months?
Thank you again. And sorry the hassle.
Daniel
Re: My Gifts
Posted: Wed Apr 01, 2015 8:28 pm
by Nikolay
Changes are correct. I can't reproduce bug with 31-march-2014.
Re: My Gifts
Posted: Fri Feb 02, 2018 9:07 am
by shawn1254
Hiiii
Your report is really nice. Thank for suggestion.......
Re: My Gifts
Posted: Sat Feb 03, 2018 1:51 pm
by Nikolay
shawn1254 wrote:Hiiii
Your report is really nice. Thank for suggestion.......
Nice to hear it.