By
I just learned something and thought I'd pass it along to people who are interested in Sage ACT dashboards and viewing them on the web.
Behind the scenes, there is an XML file located in the Tools folder under Program Files that controls what templates are available for building dashboards in Sage ACT. You can create your own SQL commands and embed them in this file by following the instructions at the top of the XML file.
Ok, so, if you add this SQL statement to the Act.dashboard.