Page 1 of 1

GRM results enhancer

Posted: Wed Mar 26, 2025 11:51 pm
by iwashere
Hello,
first time poster, newbie to mmx, hope this post is useful

So, in trying to learn GRM and tweak it to my preferences, I decided to write some javascript in a generic manner that performs the following:
- provides report-level counts of rows and sums of numeric columns
- provides group-level counts and sums
- provides some visibility enhancements to the output
- provides an expandable div allowing to copy the raw data for pasting into a spreadsheet etc.
- columns named [ Symbol ] become a browser link to view on yahoo finance.

all you do is place it in the template body, and mark any columns for subtotaling to have a [ $ ] sign in the label. There's probably a better way, but I got this method to work well.

this would need to be made currency-aware, and i've incorporated a tiny bit of custom css/classes for the money class.

Re: Javascript GRM results enhancer

Posted: Thu Mar 27, 2025 1:09 pm
by guangong
Great idea.

Would you mind having a complete GRM package for your example?

Re: Javascript GRM results enhancer

Posted: Thu Mar 27, 2025 5:52 pm
by MlinMMEX
Great job! Thank you for your contribution! @iwashere

Re: Javascript GRM results enhancer

Posted: Thu Mar 27, 2025 11:58 pm
by iwashere
sure,
line 28 I added [ $ ] to table header label so as to subtotal by that column ( be sure to sql sort by that of course )

line 83, ( before end of html tag ), paste the javascript and canvas markup and styles

look for [ my_money ] class. i had to do that because something with default "money" class was causing rendering issues.