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.
GRM results enhancer
Moderator: Renato
-
- New User
- Posts: 2
- Joined: Fri Mar 14, 2025 11:41 pm
- Are you a spam bot?: No
GRM results enhancer
- Attachments
-
- my_report_scripts.js
- javascript and markup to go in template
- (21.52 KiB) Downloaded 385 times
-
- grm_report_counts_sample.png
- example of report with totals/subtotals
- (67.68 KiB) Downloaded 269 times
Last edited by iwashere on Fri Mar 28, 2025 1:47 am, edited 1 time in total.
-
- Developer
- Posts: 658
- Joined: Wed Dec 21, 2011 5:58 am
- Are you a spam bot?: No
Re: Javascript GRM results enhancer
Great idea.
Would you mind having a complete GRM package for your example?
Would you mind having a complete GRM package for your example?
-
- Super User
- Posts: 128
- Joined: Wed Jul 24, 2024 6:16 pm
- Are you a spam bot?: No
Re: Javascript GRM results enhancer
Great job! Thank you for your contribution! @iwashere
-
- New User
- Posts: 2
- Joined: Fri Mar 14, 2025 11:41 pm
- Are you a spam bot?: No
Re: Javascript GRM results enhancer
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.
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.
- Attachments
-
- my_script_example.txt
- (24.01 KiB) Downloaded 359 times
Who is online
Users browsing this forum: Claude [Bot] and 0 guests