RDCR 201 Sample Questions

1 . The Preview tab always displays current data.
a. True b. False
Answer : b
Explaination :
The Preview tab retrieves data from the database the first time when report is run. The Preview tab may display out-of-date information until a refresh occurs.

2. The Group Tree is always available in both the Design window and the Preview
window.
a. True b. False
Answer : b
3. Select the option that does not differ between Design and Preview tabs for a report.
a. Display of page margins b. Vertical rulers
c. Page Controls d. Status bar contents
e. Field formatting options
Answer :e
4. Which of the following always makes to access database?
a. On Clicking the Refresh button
b. On Clicking the Preview tab
c. On Choosing View Preview
d. On Clicking the Print Preview button
e. On Selecting File Print Preview
Answer : a
Explaination :
On clicking the Refresh button, will always cause to new data to be retrieved. The
other options will only cause data to be retrieved if no saved data already exist.
5. Use of The Database Expert
a. Connect to Data Sources
b. Create ODBC DSNs
c. Add tables to a report
d. Link the tables used in a report
e. Add fields to a report
f. all of the above options
Answer : a,c,d
6. Planning of a report should do
a. Produce a better report
b. Speed the development process
c. Provide documentation
d. Uncover possible problems
e. Act as a sign-off point
Answers: All
7. Which of the following field types cannot be embedded in a text object?
a. Database
b. Text object
c. Formula
d. Parameter
e. Special
Answers: b.
Explanation: A text object cannot be embedded in another text object.

8. Which of the following fields is a parameter?
a. {Param}
b. {%Param}
c. {?Param}
d. {@Param}
e. {#Param}
Answers: C

9. Parameters can be given default values in order to
a. Keep the user from having to type values
b. Mask the user’s entry to restrict what can be entered in each place
c. Keep the user from entering incorrect values
d. Give the user a longer definition of coded values
e. Limit the length of the user’s entry
Answers: a, c, d.
10. Which combination of conditions might cause the first page of a report to
Display no records?
a. Keep Group Together is checked.
b. Keep Group Together is cleared.
c. Respect Keep Group Together on First Page is checked.
d. Respect Keep Group Together on First Page is cleared.
e. Repeat Group Header on Each Page is checked.
f. Repeat Group Header on Each Page is cleared.
Answers: a, c
11. Which of the following Group Sort Expert options allow you to sort based on
more than one summary field?
a. No Sort
b. All
c. Top N
d. Bottom N
e. Top Percentage
f. Bottom Percentage
Answer : b
12. In an array called Colors, equal to ['Red', 'Blue', 'Green',
'Yellow'];
Colors [2], will equal which of the following?
a. “Red”
b. “Blue”
c. “Green”
d. “Yellow”
e. Error
Answer: b.
Explanation: Crystal Reports arrays are 1-based, so Colors [2] is “Blue.”
13. What is the result of the following formula
{Order.Amount}-{@Discount}*{Quantity}+20/100
if {Order.Amount} is 200, {Quantity} is 3, and {@Discount} is 5?
a. 6.05
b. 185.20
c. 624.00
d. 184.80
Answers : b
Explanation: 200 – (5 × 3) + (20/100) = 200 – 15 + 0.2 = 185.20.

14. You can use any report file as a template by
a. Clicking the Browse button of the Template Expert
b. Clicking the Browse button of the Template screen of the report wizards
c. Saving the file to the template directory and then picking it from the
Available Templates list of the Template Expert
d. Saving the file to the template directory and then picking it from the
Available Templates list of the Template screen of the report wizards
e. Choosing File Apply Template and clicking the Browse button
Answers : a, b, c, d

15. Charts cannot be placed in which of these sections?
a. Report Header
b. Report Footer
c. Details
d. Group Header
e. Group Footer
Answers : c
16. Which of the following tabs are available on the Chart Expert?
a. Type
b. Data
c. Axes
d. Options
e. Text
Answers : All
17. 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
Answers: b,d
18.Manual running totals are created by using which three types of formulas?
a. Initialization
b. Aggregation
c. Reset
d. Display
e. Summary
Answers: c,d,e.

19. Column totals in a cross-tab can be placed at the top of the grid or at the bottom
of the grid.
a. True
b. False

Answers: a

20. You can edit which of the following field types directly from the Cross-Tab Expert?
a. SQL Expression fields
b. Running Total fields
c. Formula fields
d. Database fields
e. Parameter fields

Answers : C