Difference between revisions of "KeyStat Tabs"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (Created page with "A KeyStat Tab allows for multiple KeyStats to be combined into a single report. The tab is laid out in HTML. A notation of --X-- is used to signify where each KeyStat is pl...") |
Philip Lacey (talk | contribs) |
||
| Line 13: | Line 13: | ||
1. All users in the system: Select count(intClient_Id) as intTotalUsers from Client | 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 | 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: | In our KeyStat Tab, we create a HTML table as follows: | ||
| Line 34: | Line 35: | ||
</table> | </table> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| + | |||
| + | |||
| + | Which would look like | ||
| + | |||
| + | [[File:KeyStats-Tab.png]] | ||
| + | |||
| + | |||
| + | The report then generates as: | ||
| + | |||
| + | [[File:KeyStat-Workbook-Example.png]] | ||
Revision as of 23:55, 21 June 2014
A KeyStat Tab allows for multiple KeyStats to be combined into a single report.
The tab is laid out in HTML. A notation of --X-- is used to signify where each KeyStat is placed in the report.
A worked example:
Two KeyStats are created:
1. All users in the system: Select count(intClient_Id) as intTotalUsers from Client
2. All live users in the system: Select count(intClient_Id) as intLiveUsers from Client Where intClient_Status = 1 or intClient_Status = 2
In our KeyStat Tab, we create a HTML table as follows:
<table id="table1" style="width:100%;">
<tr>
<td bgcolor="#ff0000" width="50%" height="30">All System Users</td>
<td bgcolor="#ff0000" width="50%" height="30">--1--</td>
</tr>
<tr>
<td bgcolor="#00ff00" width="50%" height="30">Live System Users</td>
<td bgcolor="#00ff00" width="50%" height="30">--2--</td>
</tr>
</table>
Which would look like
The report then generates as:
