GRM results enhancer

GRM Reports Build and share your cool customized reports built w/ SQL, JS and Lua

Moderator: Renato

iwashere
New User
Posts: 2
Joined: Fri Mar 14, 2025 11:41 pm
Are you a spam bot?: No

GRM results enhancer

Post 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.
You do not have the required permissions to view the files attached to this post.
Last edited by iwashere on Fri Mar 28, 2025 1:47 am, edited 1 time in total.
guangong
Developer
Posts: 654
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No

Re: Javascript GRM results enhancer

Post by guangong »

Great idea.

Would you mind having a complete GRM package for your example?
MlinMMEX
Super User
Posts: 124
Joined: Wed Jul 24, 2024 6:16 pm
Are you a spam bot?: No

Re: Javascript GRM results enhancer

Post by MlinMMEX »

Great job! Thank you for your contribution! @iwashere
iwashere
New User
Posts: 2
Joined: Fri Mar 14, 2025 11:41 pm
Are you a spam bot?: No

Re: Javascript GRM results enhancer

Post 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.
You do not have the required permissions to view the files attached to this post.