Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
no edit summary
1. All users in the system: Select count(intClient_Id) as intTotalUsers from Client
[[File:KeyStat-1.png]]
2. All live users in the system: Select count(intClient_Id) as intLiveUsers from Client Where intClient_Status = 1 or intClient_Status = 2
[[File:KeyStat-2.png]]
In our KeyStat Tab, we create a HTML table as follows:
</table>
</syntaxhighlight>
Which would look like
[[File:KeyStats-Tab.png]]
The report then generates as:
[[File:KeyStat-Workbook-Example.png]]
