Level 2 exam — SAP Crystal Reports

Exam — fresh questions

12 new questions: recall + application + arbitration on sorting, grouping & selection.
Answer everything, then click Check: your score and explanations will appear.

2.1 · Recall

1. What does grouping create around detail rows?

An automatic selection filter No extra section A Group Header and a Group Footer section A new database table

The Header names the group, the Footer will hold its subtotals (2.2).

2.1 · Application

2. Farès wants a Region > Customer report. How does he order his groups?

Two groups at the same level with no order Customer first, Region next A single sort with no group Region as outer group, Customer nested inside

Order defines the hierarchy: the broadest level first.

2.2 · Recall

3. Where to place a summary to get a per-group subtotal?

In the Group Footer In the Details section In the Report Footer In the Page Header

Group footer = group subtotal; report footer = grand total.

2.2 · Application

4. Farès's grand total exceeds the accounting figure by 12%. First reflex?

Add an extra group level Check join duplicates and cross-check the total Change the Sum operation to Average everywhere Remove all groups from the current report

A one-to-many join duplicates amounts and inflates sums.

2.2 · Arbitration

5. Farès wants the number of orders AND the total amount per customer. What does he pick?

Two Counts of the amount in the report footer A single overall Average for both needs Two Sums of the amount at two levels A Count of orders and a Sum of amounts, each at the right level

“How many?” → Count; “what total?” → Sum, level per scope.

2.3 · Application

6. Farès's report (2 million rows) is slow to run. What does he check first?

That the filter is in the WHERE clause (server-side) The colour applied to subtotals The font used in group headers The number of nested group levels

Server-side, the database returns only what is needed; client-side fetches everything then filters.

2.3 · Application

7. Farès wants 2026 orders from the North region. Which selection formula?

Count({Commandes.Montant}) > 1000 as selection filter {Commandes.DateCommande} in Date(2026, 1, 1) to Date(2026, 12, 31) and {Clients.Region} = "North" Year({Commandes.DateCommande}) = 2026 with no region condition {Clients.Ville} in ["Algiers", "Oran"] with no date condition

Two simple conditions on base fields, combined with AND, pushed to WHERE.

2.3 · Arbitration

8. “City = Algiers AND City = Oran” returns nothing. Farès's diagnosis?

The filter must go client-side A group per city must be added Impossible AND: one city cannot be both — use OR or “in the list” The date filter must be removed

Everyday “and” often becomes a logical OR on one field.

2.4 · Recall

9. What is a Crystal Reports parameter?

A section suppressed by default A table added to the database A font asked for at print time A value asked from the user at runtime, adapting the report

Name, clear prompt, type and options; the report adapts to the input.

2.4 · Application

10. Farès replaces “hard-coded Year = 2026” with “= {?Year}”. What gain?

One template serves all years, picked at runtime Groups disappear from the report The report gets slower but nicer Totals are no longer filtered

The parameter wired to selection makes the report generic and reusable.

2.5 · Application

11. Management wants a one-page summary from Farès's detailed report. Correct move?

Add columns to the detail Suppress the Details section (already grouped and totalled report) Change the details' font Remove groups and subtotals

Headers (names) and footers (subtotals) remain: the summary view.

2.5 · Arbitration

12. Farès's conditional suppress formula hides everything except zero rows. Mistake?

The report should have been duplicated One more group is missing Reversed direction: when suppressing, True = suppressed — invert the condition None: the direction is always intuitive

Test the formula with varied data before releasing.

What's next?

Score ≥ 80%: move to Level 3 — formulas and conditional formatting, keeping your reflexes (groups, summary levels, checked WHERE, wired parameters).
Score 60-79%: revisit missed sections (2.1 hierarchies, 2.2 levels/operations, 2.3 AND/OR logic and server, 2.4 parameter options, 2.5 suppress direction) and redo the 48h challenges.
Score < 60%: rebuild Farès's report step by step (1 group, 1 subtotal + 1 cross-checked grand total, 1 checked filter, 1 tested parameter, 1 suppressed summary), then retake the test.
In all cases: keep the reflexes — structure before totalling, cross-check totals, push filters database-side.