MMEX Desktop v1.3.4.rc.2 is ready https://sourceforge.net/projects/moneym ... 1.3.4-rc.2

My Gifts

Build and share your cool customized reports built w/ one sql, Chart.js and Lua (https://github.com/moneymanagerex/general-reports)
Post Reply
Nikolay
MMEX Developer
Posts: 1176
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

My Gifts

Post by Nikolay »

gifts_sample.png
gifts_sample.png (15.17 KiB) Viewed 1951 times
-------------------------------------------
Attachments
My_Gifts_v1.grm
(2.58 KiB) Downloaded 680 times

Nikolay
MMEX Developer
Posts: 1176
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: My Gifts

Post by Nikolay »

Updated report with currency formating and difference between deposits and withdrawals and columns sorting.
Attachments
My_Gifts_v3.grm
(3.25 KiB) Downloaded 805 times

dca_sonic
New MMEX User
Posts: 10
Joined: Sun Mar 18, 2012 8:24 pm
Are you a spam bot?: No
Location: Brazil

Re: My Gifts

Post 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

Nikolay
MMEX Developer
Posts: 1176
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: My Gifts

Post 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

dca_sonic
New MMEX User
Posts: 10
Joined: Sun Mar 18, 2012 8:24 pm
Are you a spam bot?: No
Location: Brazil

Re: My Gifts

Post 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

Nikolay
MMEX Developer
Posts: 1176
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: My Gifts

Post by Nikolay »

Changes are correct. I can't reproduce bug with 31-march-2014.

shawn1254
New MMEX User
Posts: 1
Joined: Fri Feb 02, 2018 9:03 am
Are you a spam bot?: No

Re: My Gifts

Post by shawn1254 »

Hiiii

Your report is really nice. Thank for suggestion.......:)

Nikolay
MMEX Developer
Posts: 1176
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: My Gifts

Post by Nikolay »

shawn1254 wrote:Hiiii

Your report is really nice. Thank for suggestion.......:)
Nice to hear it.

Post Reply