SAP
C_BOCR_11 · Question #207
You must link two tables on an employee ID field in a Crystal report. The parent table's field is a string, but the child table's field is a number. How can you create a report that joins child and…
The correct answer is B. Convert the parent table's field to a number and link a subreport on this value. See the full explanation below for the reasoning.
Question
You must link two tables on an employee ID field in a Crystal report. The parent table's field is a string, but the child table's field is a number. How can you create a report that joins child and parent information so that only those records where the primary keys match are returned?
Options
- AUse an unlinked subreport in the report header to display all data from the child table.
- BConvert the parent table's field to a number and link a subreport on this value.
- CLink a subreport on a parameter field and use the parameter to display data from the child
- DUse an unlinked subreport in the report footer and conditionally suppress unnecessary data.
How the community answered
(38 responses)- A3% (1)
- B76% (29)
- C8% (3)
- D13% (5)
Community Discussion
No community discussion yet for this question.