GRM Reports Explorer!

[guangong]

Explore all existing reports

1. Explorer: http://grm.moneymanagerex.org/
2. package: https://github.com/moneymanagerex/gener ... s/releases

[PetalPower]

I have been exploring them. Most of them do not work correctly.

[Renato]

See: https://github.com/moneymanagerex/money ... ssues/5567

[guangong]

Hi @PetalPower ,

Can you point out which ones with details? Today, the link will run the SQL per clicking, at least there is no SQL syntax issue

[PetalPower]

@guanlisheng CategoriesStatLast12months is the one I've been trying to get to work. The graph doesn't show, the titles don't show month names, the report title wasn't working but I fixed that on mine by adding the VAR, the bottom totals row does not show. Someone else had also posted recently about this same report so I know at least 2 of us would appreciate a fix. I can add other reports when I have more time this afternoon.

A category picker would be soooo extremely helpful. I've been trying to pull just 2 categories out but I haven't been able to get it exact. My coding skills are low but I haven't decided if it's my code or other issues from it not working properly in the first place.

https://moneymanagerex.org/general-repo ... ryForecast

[PetalPower]

@guanlisheng
Reports -> Categories-> Monthly
Could replace all of the category reports in General Report Manager if it had a category picker and a real date picker. Another alternative would be to be able to pick a different template in the Transaction report (one that looks like the Category Report). It already has all the information we need and the option to include/exclude any data we want. This would save time for users and coders over frustration and maintenance.

I pulled code from GitHub and generated templates from the template generator in MMEX. They give slightly different results, I'm guessing because those on Github are not updated. Also, the General Report Manager doesn't generate LUA files so there's some difference there for views.

ONE CATEGORY LIST
Titles work but no data is shown, also the code at the top to retrieve the category numbers is not correct.
I used this to pull mine in a separate report I named Category List:

SELECT
c.categid,
CASE
WHEN p.categname IS NOT NULL THEN p.categname || ': ' || c.categname
ELSE c.categname
END AS combined_name
FROM
category_v1 c
LEFT JOIN
category_v1 p
ON
c.parentid = p.categid
ORDER by combined_name asc;

-----------------------------
EXPENDITURE HISTORY
The table Titles are not correct
looks like there should be a graph that's not showing
no total rows at the bottom? (Probably LUA related)


-------------------------
EXPENSES AND REVENUE BY YEAR - OK
EXPENSES AND REVENUE BY QUARTER - OK
EXPENSES AND REVENUE BY MONTH - OK
DepositVsExpensesAndLoanRepaymentByMonth - OK

[guangong]

Thanks @PetalPower

Built-in reports and general reports share the same database data source while serve different purposes with distinguished capabilities and flexibilities.

Especially for these sql experts like you, you can create your own great reports easily and shortly.

In the meantime, these reports would be reviewed, refined, deleted and moved to built-in ones regularly.

You are one of the reviewers now.
Good news is that GRM reports would be released independently and rapidly.

[guangong]

hi @PetalPower

Just fixed a CSS and JS issue by adding memory: prefix, can you download the GRM package and have a try again?

[PetalPower]

@guanlisheng Which report did you work on and where is it updated?

[guangong]

here you go

https://github.com/moneymanagerex/gener ... s/releases

[PetalPower]

@guanlisheng No change on the CategoriesStatLast12months report. I don't have time to check the others until Monday.

[MlinMMEX]

Hi @guanlisheng so, to understand...

In version 1.8.x , reports in GitHub were not working.
viewtopic.php?p=25314#p25314

... but in version 1.9.x, the reports in the build version and to be imported are not the last ones...
... the last ones are then in GitHub GRM repository, again?
https://github.com/moneymanagerex/gener ... s/releases

[guangong]

Please check out the latest (and working?) version from GitHub and reimport it. Some graphics might still not work well and it requires some knowledge of ChartNew.js

[guangong]

hi @PetalPower , part of charts are working since v2.0.2 https://github.com/moneymanagerex/gener ... tag/v2.0.2

[PetalPower]

@guangong The dates are showing correctly, yay! I can't help at all with Chartnews.js