When looking at the join types in Crystal - what does it mean when you coose E

When looking at the join types in Crystal - what does it
mean when you coose Enforce and Enforce To or Enforce From

Question Posted / trainme

3 Answers
14161 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce T..

Answer / jahnavi

if you choose enforce to for a join type table a and table
b and you select only fields from table a even then table b
is included.

if you choose enforce from for a join type from tableA and
table B and you select only fields from table B still the
table A is included.

Is This Answer Correct ?

6 Yes

3 No

When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce T..

Answer / sajal kumar

Version 10 introduced the capability to enforce link created in report. Enforcing a link between two tables ensures that the report's respective SQL uses this link, regardless of whether fields are required from one or both the involved tables.
The default setting is unenforced links, meaning that Crystal Reports uses the link only if the report's respective SELECT statement requires it.
You can access the different enforcement option by right-clicking on a link and selecting the link Options menu item.

Is This Answer Correct ?

3 Yes

0 No

When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce T..

Answer / rajesh

can u give me any example and answered clearly

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Crystal Reports Interview Questions

Is there a size limit to creating a Crystal Report? If I run a statement report for all customers it will crash if there are too many customers. I can print all the statements if I select them in batches, but if trying to print all at once Crystal will crash after a few minutes.

0 Answers

hi.. i've created one crystal report. and one global resource file .. in crystal report there's one text object with id Text1. and i want to take the values of resource file i've got it CrystalDecisions.CrystalReports.Engine.TextObject Dtemp1 = ((CrystalDecisions.CrystalReports.Engine.TextObject)myreport .ReportDefinition.Sections["section1"].ReportObjects["Text1" ]); Dtemp1.Text = Resources.Resource.ResourceManager.GetString("Dsec1"); it is showing the correct value want i want but when i give print it is disappearing.. how to solve this please help me..

0 Answers

Reports can be optimized for web viewing using which of the following strategies: a. Using subreports instead of linking tables b. Avoiding maps c. Using the Page N of M special field to help users understand how many pages are in the report d. Saving reports as version 10 e. Avoiding reports with drill-down capabilities

2 Answers

Is there a way to export the report formulas, like totals to excel?

3 Answers

What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions)?

0 Answers

reporter footer contents are move depend the page footer values...........

2 Answers

Where can we find the log file generated when we run a crystal report?

0 Answers

Explain the various components in crystal reports?

0 Answers

Is there a way to export a report definition without writing code?

2 Answers

how should i highlight a particular column in a report in actuate e designer report? It should be done dynamically while creating report Thanks in advance!!!!!!!!!!

0 Answers

If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?

0 Answers IBM,

I have a crystal report with a linked subreport as well. is there any way not to print the current record on the main report if no records are returned from the subreport? thanks you email - stanlte@yahoo.com

3 Answers

For more Crystal Reports Interview Questions Click Here