Geek asks and answers

What is the advantage of the Enforce Join option in Crystal Reports?

What’s the advantage: SAP Crystal Reports Enforce reports Do not force a default join in the Link Dialog dialog box?

Is this a performance issue? because I noticed that if you do not select a field from a joined table, it will generate a SELECT query only with the fields of the selected table without any connections.

here is some information about Enforce Join options:

  • Laid-back . When you select this option, the link you created only if it is explicitly the required Select expression. This is the default option. Your users can create reports based on selected tables without restriction (that is, without based on other tables).

  • Forced from . When you select this option, if the "to" table for the link is used, the link is forced. For example, if you create a link from Table A to Table B using Enforce From and select only the field from Table B, the Select statement still includes joining Table A because it is respected. Conversely, choosing only from table A with the same join condition will not cause a connection with table B to be observed.

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

  • . , "from", "to" , .

+3
1

"" FORCE , , /.

, , , .

:

(tbl_A, tbl_B) , , , "" .

Select 
   'You're account is in default!' as Message,
   tbl_A.full_name, tbl_A.street_address, tbl_A.city, tbl_A.blah_blah
From
   all_customers tbl_A, 
   delinquent_accounts tbl_B
Where
   tbl_A.account_no = tbl_B.account_no


Select 
   'You're account is in default!' as Message,
   tbl_A.full_name, tbl_A.street_address, tbl_A.city, tbl_A.blah_blah
From
   all_customers tbl_A,

, , . ( , ).

+8

More articles:


All Articles