Crystal Reports  

Link Options Dialog Box

Use the Link Options dialog box to specify join and link types.

This dialog box appears when you have a link line selected and you click the Link Options button in the Links tab of the Database Expert.

Link Display
This box describes the selected link.
Join Type
The program enables you to specify the type of join you want it to use when joining SQL tables.
Enforce Join
The program enables you to enforce the use of tables while you're specifying joins:
  • Not Enforced

    When you select this option, the link you've created is used only if it's explicitly required by the Select statement. This is the default option. Your users can create reports based on the selected tables without restriction (that is, without enforcement based on other tables).

  • Enforced From

    When you select this option, if the "to" table for the link is used, the link is enforced. For example, if you create a link from Table A to Table B using Enforce From and select only a field from Table B, the Select statement will still include the join to Table A because it is enforced. Conversely, selecting only from Table A with the same join condition will not cause the join to Table B to be enforced.

  • Enforced To

    When you select this option, if the "from" table for the link is used, the link is enforced. For example, if you create a link from Table A to Table B using Enforce To and select only a field from Table A, the join to Table B will be enforced, and the Select statement that is generated will include both tables.

  • Enforced Both

    When you select this option, if either the "from" table or the "to" table for this link is used, the link is enforced.

Link Type
The program enables you to specify the type of link you want it to use when joining tables.

See Also

Links Tab (Database Expert) | Accessing and Adding Data