Input Criteria

Input Criteria can help ensure the integrity of the date entry when filling a data report in Excel.

General

1. Criterion Name: the name of the data selection, such as: ProductName and ProductType

2. Style

3. Data Source

4. Manual input is allowed when fill: when filling the data, if the dropdown list box or the tree-view does not contain the required data, then the needed data can be directly typed into the cell. (This feature does not apply to the Web user interface).

Applied to

System Built in Data Selection

    Department Name

    Current Date

    Current User Department

    Current User Name

    Roles

    Users

    User Organization

    CurrentDeptId

    CurrentLogin

 

Excel Server homepage