KeyStat Tabs - Revision history

Philip Lacey at 20:34, 9 November 2014

2014-11-09T20:34:06Z

Philip Lacey at 22:55, 21 June 2014

2014-06-21T22:55:59Z

Philip Lacey: 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..."

2014-06-21T22:43:00Z

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..."

New page

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:

<syntaxhighlight lang="html4strict">
<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>
</syntaxhighlight>

← Older revision		Revision as of 20:34, 9 November 2014
Line 45:		Line 45:

	[[File:KeyStat-Workbook-Example.png]]		[[File:KeyStat-Workbook-Example.png]]
		+
		+
		+	[[Category:Module Specific:KeyStats]]
		+	[[Category:Topic:Reporting‏‎]]

@@ Line 13: / Line 13: @@
 . All users in the system: Select count(intClient_Id) as intTotalUsers from Client
 . 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:
@@ Line 34: / Line 35: @@
 </table>
 </syntaxhighlight>