Level 0 exam — SAP Crystal Reports

Exam — fresh questions

12 questions to validate getting started with Farès: what Crystal Reports is for, which edition to install, how to file the interface, and how to connect without wrong totals.
Answer everything, then click Check: your score and explanations will appear.

0.1 · Recall

1. What does Crystal Reports do with data?

It deletes it after display It connects to it at the source and presents it in a statement It calculates it like a spreadsheet It types and stores it internally

Presentation tool: data stays at the source, the report is a refreshable template.

0.1 · Application

2. Farès produces the same sales statement every month. Which organisation?

Print once and photocopy the same PDF all year Ask the database to change its figures Retype figures and redo the layout every month in Excel Design a Crystal Reports template once, then refresh it every month

Fixed presentation + up-to-date data: a template designed once, refreshed at will.

0.1 · Application

3. Farès must: (A) explore an exceptional variance, (B) produce 500 paginated invoices. How to split?

Do everything in Crystal Reports, including exploration Explore the variance in Excel (A), produce the invoices in Crystal Reports (B) Do everything in Excel, including the 500 invoices Refuse both tasks

Free one-off analysis → Excel; fixed repeatable document → Crystal Reports.

0.2 · Recall

4. Which edition should Farès install to learn to design statements?

Crystal Reports for Visual Studio Enterprise / SAP BO only None, everything is done online The standalone designer via the trial edition

Standalone designer = design; for Visual Studio = .NET integration; Enterprise = mass distribution.

0.2 · Application

5. Farès is on Mac and wants to follow this guide. What should he do?

Use a Windows virtual machine then install the designer in it Give up, Crystal Reports cannot be learned Install the native Mac designer Install for Visual Studio on Mac

Windows-only designer: on Mac, Windows virtual machine, recent version (2020).

0.2 · Arbitration

6. A colleague says: “Let us take for Visual Studio, it is free so it equals the designer”. Farès’s verdict?

To refuse: for Visual Studio embeds in .NET, not standalone design — take the designer via the trial To refuse: Enterprise is needed in all cases To accept: free = identical To accept if we still pay for a licence

Each edition has its use: design (designer), integrate (Visual Studio), distribute (Enterprise).

0.3 · Recall

7. Where does Farès place the grand total so it appears only once?

In Details In the Page Header In the Report Footer Anywhere, it is the same

Details repeats per row; the Report Footer displays only once, at the end.

0.3 · Application

8. Farès put his title in Details: it repeats on every row. What to fix?

Delete the title permanently Move the title to the Report Header (1×) and check in Preview Duplicate the title in each section Change the title font

The section decides frequency: single title → Report Header, check in Preview.

0.3 · Arbitration

9. Farès builds everything in Design without ever opening Preview. Verdict?

To fix: everything must be done in Preview Good method: Preview is useless Good method if sections are right To fix: Design shows structure, only Preview shows the real rendering — alternate both

Normal loop: build in Design, check with data in Preview, fix, recheck.

0.4 · Application

10. Farès links Customers and Orders. What is the join based on?

On the number of columns On the file name On a common field (Clients.ID = Commandes.ClientID) On the colour of tables

No link on a common field: duplicates, missing rows or cartesian product.

0.4 · Application

11. Farès’s revenue looks doubled after the join. First reflex?

Hard-code the password to go faster Distribute anyway, the report looks fine Cross-check against the known revenue and check the link and join type (one-to-many, inner vs outer) Add all other tables of the database

Join errors are silent: cross-check totals before distributing.

0.4 · Arbitration

12. Connection impossible: “source not found” via ODBC. Where does Farès start?

He checks the driver and the 32/64-bit architecture of the DSN, then parameters, rights and network He hard-codes his password in the report He loads all tables to force the connection He reinstalls the whole workstation

No. 1 cause of ODBC failures: 32/64-bit mismatch between software and driver — exact message first.

What's next?

Score ≥ 80%: move to Level 1 — first statement with the wizard, with Farès.
Score between 50% and 80%: review the failed section(s) (0.1 reporting, 0.2 installation, 0.3 sections, 0.4 connection), reread the explanations above, then retake the test.
Score < 50%: reread all of level 0 applying each 48h challenge (scoping sheet, installation checklist, filing 5 objects, connection + cross-checked total) before retrying.
And next? Keep Farès’s connection sheet and sections grid: level 1 uses them to place the first fields.