Table of Contents
Link Conditions
Link Conditions are used to control how, and when, an action is executed. Examples might include:
- Open a list of open invoices sub-report only if the customer’s account balance is not zero.
- Open a URL only if the UPS tracking number value is not blank. Otherwise, take no action. Conversely, use a different URL if the FedEx tracking number is not blank. Note that these conditions are on different link fields.
- Execute a Crystal Report if the document type is an invoice. Otherwise, take no action. Conversely, execute a different Crystal Report if the document type is a credit memo. Note that these conditions are on different link fields.
Add/Maintain Action Conditions
To add or modify Action Conditions:
- Move to the “Actions” step of the report wizard.
- Add a new action or select the row of an existing action.
- Click the [Conditions] button.
- The “Action Conditions” tool is displayed.
In this example, we want to display a sub-report of open invoices only if the current balance is $10,000 or greater. If the balance is less than $10,000 the sub-report should not be displayed when the action link is clicked.
Create the condition formula as described below. Do not enter the formula directly in the “Preview” area as the condition will not function in the report. The preview is simply a way for you to see how the formula is constructed.
- Build the formula from left to right using the element tools as shown.
- The “Open Bracket” and “Close Bracket” are only required in complex conditions.
- Select the comparison value from the “Report Field” drop-down list.
- Select the comparison operator from the “Operator” drop-down list.
- Enter the first comparison value in “Value1.”
- Enter the second comparison value in “Value2” if the “between” operator is being used.
- Select the “Logical Operator” (AND, OR) if needed to add more condition information.
- Click [Preview] to see the completed condition statement.
- Click [Submit] to save the condition.
- Click the red X at the right end of a condition line to remove the condition statement.