Managing Info Pages

  1. In the Data Models and Views tab, right-click a Data Model and select Manage Info Pages.

  2. In the Manage Info Pages window, click Add New Record to create a new script or to edit an existing script.

    Tip

    At any point, you can see a preview of the Info Page by clicking Preview Info Page, which will open up the preview in a pop-up window.

  3. Select and configure the appropriate scripts.

    The Script Name and Description fields determine what will appear above and to the right-hand side of the script. You can delete the current script by clicking .

    Within each script several controls are available on the right side of the screen, which can be dragged and dropped within the script.

    Once within the script, each control can have its relative position changed by dragging it to the desired location. A control can be deleted from a script by clicking .

  4. Click Update.

Control Property Description
Name Defines the name of the control itself. It can be used in the script executed by the button.
Label Text Text displayed for the control.
Interval Determines if only one value can be entered (not checked) or two values (interval).
Show Prompt Button Determines if we attach a prompt to the control .
Type

Choose the type of control:

  • Select Menu: Allows you to define the list of values that will be displayed in the Select Menu.

  • TextInput

  • Checkbox

  • DatePicker

  • Button: This is an important control. One of its properties is the SQL Command, where the desired SQL Script can be configured.

    Within the SQL Script, the names of the various other controls in the Info-Page script can be passed as a parameter, by enclosing them in @ characters.

    The script will be executed in whatever database is specified by the Data Source selected in the Data Source drop-down list.

    Tip

    It is also possible to use Stored Procedures and Global parameters in the SQL Command (ex: EXEC @LIB_STOREDPROCABC @Year@, @Period@, @Budget@) .

    Example

    In the example below, ForecastName, ForecastType and Company are controls in the script.