Level 5 exam — SAP Crystal Reports

Exam — fresh questions

12 new questions to validate Distribution, integration & best practices: exporting, dynamic and cascading parameters, application integration, performance and best practices.
Answer everything, then click Check: your score and explanations will appear.

5.1 · Recall

1. Which format does Farès choose to distribute a finalized invoice to read and archive?

An Excel “with page layout” A fixed, faithful, non-editable PDF An image file of the report A raw CSV for system import

Reading/printing/archiving a fixed document → PDF, universal and non-editable.

5.1 · Application

2. Farès's analysts must sort and calculate on monthly figures. What does he send them?

A laid-out Word document An Excel “with page layout” with merged cells A “data only” Excel with clean, usable cells A PDF to retype by hand

Analyze/rework → “data only” Excel; the “page layout” export blocks pivot tables.

5.1 · Application

3. Farès's PDF overflows in width, right columns spill onto separate pages. First reflex?

Switch to landscape and check the printable area before distributing Send anyway, readers will paste back together Convert to an image Delete data at random

Overflow → landscape, adjusted columns, verified printable area, always check before sending.

5.2 · Recall

4. What is a dynamic parameter in Crystal Reports?

A value list fed automatically by the database, up to date A parameter that changes the font An automatic PDF export A fixed hand-typed list

The list reflects real database values (new customer visible on its own) without maintenance.

5.2 · Application

5. Farès organizes division → department → cost center. What happens when a division is chosen?

Nothing, the three lists stay independent The report exports immediately The lists empty out The department list is restricted to that division's departments

Cascade: each choice filters the next — reduced, guided lists, with no invalid combination.

5.2 · Application

6. Farès's huge cost-center dynamic list makes opening slow. What does he do?

He duplicates the report per cost center He switches everything back to free typing He limits the list and caches it, keeping server-side filtering He deletes all parameters

Populating a list costs an opening query: limit and cache huge lists.

5.3 · Application

7. Farès wants a “Print budget” button in the ERP. Who does what?

Install the designer for each department head Farès creates the .rpt, the developer integrates it via viewer, connection and parameters Farès codes the whole application alone Copy the .rpt to the server, with no code or runtime

Designer (.rpt, parameters) + developer (viewer, in-code connection, deployed runtime).

5.3 · Arbitration

8. Reports display on no workstation although the code looks right. Farès's call?

Abandon integration Reinstall the designer everywhere Hard-code credentials to unblock First check that the Crystal runtime is deployed on target workstations

Without a deployed runtime, no report displays — the classic omission to check first.

5.3 · Arbitration

9. The developer suggests hard-coding database credentials to go fast. Call?

Accept, it is faster Put passwords in the shared .rpt Give everyone maximum rights Refuse: supply the connection in code with rights limited to need

Never hard-code credentials: in-code connection, limited rights, parameters by user.

5.4 · Recall

10. What is the #1 performance lever for a report over large volumes?

Bring everything back then filter on the workstation Add colors Filter server-side: bring back only what is needed (check the SQL) Multiply subreports in Details

Minimize brought-back data and push work to the database — the filter must be in the WHERE.

5.4 · Application

11. Farès's grand total does not reconcile with accounting. First suspect?

The export format A dubious join creating duplicates that inflate totals The color of totals The font

Join duplicates = trap #1: check links, reconcile against a known value, handle nulls.

5.4 · Arbitration

12. Management presses Farès to distribute the closing, tested only on 100 rows. Call?

First test on real volume: accurate and clear before fast, never distribute untested Distribute at once, the sample is enough Polish appearance instead of testing Refuse to test to save time

Fast on 100 rows says nothing about a million: reconciled accuracy + real test before any distribution.

What's next?

Score ≥ 80%: move to Level 6 “In practice” — real cases, troubleshooting and Crystal Reports toolbox (NO exam).
Score 50-79%: reread the explanations above — each re-explains the concept — then redo the 48h challenges and template sheets of failed sections.
Score < 50%: revisit sheets 5.1 (one format per use) and 5.4 (push to the database, reconcile, test), your two vital moves, before continuing.