To set up rules for advanced defaulting behavior or calculating column totals, configure any required table logic, as follows:
You can configure table rules in the same way you configure advanced request type rules. That is, you can configure fields (columns) in the table to default to certain values based on an event or value in another field in the table. Because the table component rules are configured using an SQL statement, you have enormous flexibility for the data that populates the table cells.
Follow the instructions in Configure table component.
Click the Rules tab.
Do either of the following:
Create a rule
Create a rule
Provide a name for the rule.
Provide a description of the rule.
Indicate whether this rule is active or not.
Select a value from the list.
Process subsequent rules?
This rule could trigger other rules, indicate if the triggered rules should be followed or ignored.
Use the New, Edit, and Remove buttons to indicate column dependencies. For example:
Column = Price [All Values = Yes]
Column = Quantity [All Values = Yes]
Use to indicate results columns.
Column Header = Total
Define the logic associated with the rule. Can be SQL Default or UI Rules.
For example, the SQL could be:
SELECT [TE.P.PRICE] * [TE.P.QUANTITY], [TE.P.PRICE] * [TE.P.QUANTITY]
For information on how to work with UI Rules, see the Demand Management User Guide.
For detailed examples, see Example of Using a Table Component on an Order Form.
Click OK or Add.
Copy a rule from other table components
Click Copy from.
The Copy Rules window opens.
In the Validation field, select a validation where you want to copy the rule and click OK.
All the rules of the selected validation are loaded in the Copy Rules window.
Select the desired rule and click OK.
Click OK or Save.