Key Stat - Data List
From All n One's bxp software Wixi
1 Overview
bxp has the ability to allow users to render on screen a custom data listing of data from inside one of there forms. This can be achieved by useing a custom SQL statement.
2 Creating a Key Stat Data Listing
To create a Key Stat Data Listing you must first navigate the following system path:
Main Menu > Key Stats > KeyStat - Add
Once here you will need to input the following settings to successfully create a Key Stat Data Listing.
1) Title - This should be an easily identifiable title for the key stat
2) Type - Set this to be Value
3) Query - Field(s) - This field should contain the fields that are being returned as part of you SQL statement (The fields should be separated by a ,)
4) Query - SQL - This field should contain the custom SQL statement that will get all of the information that you require.
5) Display Title - This is the headings that you want the information retrieved to have (The fields should be separated by a ,)
