...
Note |
---|
To build a canned panel, you may open Panel Settings thru: a. Panel Settings New button > New Canned Panel Image Removed Image Added
b. Panel List New button > New Canned Panel Image Modified
Owner will be automatically set to Canned Panel. ![](/download/attachments/4489991/image2016-1-13%2014%3A39%3A7.png?version=1&modificationDate=1452667288067&api=v2&effects=border-simple,shadow-kn)
|
Expand |
---|
|
Building new panel in the Dashboard can be accomplished to fulfill your specific requests. These steps focus on the fields to complete in the Panel Settings form. On Dashboard menu, double click the Add Panel menu to open a blank Panel Settings screen.Enter in the appropriate information in the Panel Settings screen. See below for the description of each field.
Image Removed
- Panel Name: Enter the name the panel will be called.
- Class: Master will be used most often.
- Rows Retrieved: Select the number of rows you want to return data, select 0 to return all data (recommended).
- Panel Caption: Title of the panel, which will be display on Dashboard.
- Style: Choose which type of panel you want to create; Grid, Pivot Grid or Chart. When the you set up different sets of column settings, changing the Style of the Panel will respect the columns selected for the particular style (Grid or Pivot Grid). It's most likely Style per Column Settings setup.
- Rows Visible: Select the numbers of records you want to display on dashboard.
- Description: Enter any comments or descriptions of the panel.
- Query: Enter or build your query here. The TOP keyword is well supported when the data connection is MySQL.
- Date Condition: Select from the combo box the Date condition you want to default to, if using this option.
- Date Variable: Enter “@DATE@” or #DATE# if used.
- Date Field: Enter the field that you want the Date Condition to pull from.
- Other Filter: By default is None. Select the appropriate Filter Name from the combo box list.
- Filter Variable: Enter "@FILTER@" or #FILTER# if used.
- Filter Field: Enter the field that you want the Other Filter to pull from.
- Connection: Select the appropriate Connection Name from the combo box list from where the panel will be accessing the database.
- Owner: This field is disabled.
- Drill Down: Select the panel that you wanted to be drilled down. This field is disabled though when Style is Chart.
- Column Settings:
Column Name: Select the Alias or field that you want to display from the entered query Caption: Enter the title you will want to call this column.Width: How long do you want the field to be.Align: Left, Center, or RightFooter: Choose from combo box list, you can Sum this field as well as much more.Format: Choose from many options on how you want the data to display in the panel. Note |
---|
You can use the Fill Columns button to fill in the Column Settings field with the fields specified in the Query. See sample below. Image Removed
Image Removed
| When finished, click the Save |
...
To build a canned panel, you may open Panel Settings thru:
a. Panel Settings New button > New Canned Panel
Image Removed
b. Panel List New button > New Canned Panel
Image Removed
Owner will be automatically set to Canned Panel.
...