985: gifts_sample.png
-------------------------------------------My Gifts
Moderator: Renato
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
My Gifts
-------------------------------------------
You do not have the required permissions to view the files attached to this post.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: My Gifts
Updated report with currency formating and difference between deposits and withdrawals and columns sorting.
You do not have the required permissions to view the files attached to this post.
-
- New User
- Posts: 11
- Joined: Sun Mar 18, 2012 8:24 pm
- Are you a spam bot?: No
- Location: Brazil
Re: My Gifts
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
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
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: My Gifts
Hi Daniel,
Try to change SQL line 14to
Try to change SQL line 14
Code: Select all
where (date('now', 'start of month','-11 month','localtime') <= c.transdate
Code: Select all
where (date('now', 'start of month','-12 month','localtime') <= c.transdate
-
- New User
- Posts: 11
- Joined: Sun Mar 18, 2012 8:24 pm
- Are you a spam bot?: No
- Location: Brazil
Re: My Gifts
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
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
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: My Gifts
Changes are correct. I can't reproduce bug with 31-march-2014.
-
- New User
- Posts: 1
- Joined: Fri Feb 02, 2018 9:03 am
- Are you a spam bot?: No
Re: My Gifts
Hiiii
Your report is really nice. Thank for suggestion.......
Your report is really nice. Thank for suggestion.......
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: My Gifts
Nice to hear it.shawn1254 wrote:Hiiii
Your report is really nice. Thank for suggestion.......