InetSoft's reporting software allows users to sort data so that they get highest level of customization necessary for their industry. View the example below to learn more about the Style Intelligence solution.
The ‘Create Expression’ link can be used to create a new formula using the Formula Editor, just like creating a new expression in the ‘Data Query’ interface.
When there are multiple conditions you need nested conditions to define the order in which the conditions are evaluated by the logical operators. Consider a scenario where you want to find exceptional orders at both the low and high end. To satisfy this constraint the first two conditions are connected by ‘or’ and indented. Then ‘and’ this pair with the third condition.
If you add all three conditions first, you can then select and move them into the proper order (use ‘Up’ and ‘Down’). Then select the logical operator (i.e. ‘or’) and click ‘indent’. The ‘unindent’ button performs the inverse.
The ‘Browse Data’ button displays a list of the unique values in the selected column. (For performance reasons, only the first 1000 rows are scanned.) For example, in the filtering dialog box, the ‘Browse Data’ button reveals all the distinct values in the ‘Product.Category’ column.
If desired, you can be prompted for a condition value before the report is generated. Click the ‘Parameter’ button and enter a label, e.g., ‘Category’. Also check the ‘use selection list’ box. This option will ask you to select a category from all possible values.
Copyright © 2024, InetSoft Technology Corp.
