Level 1 exam — SAP Crystal Reports

Exam — fresh questions

12 questions to validate Beginner: building your first report — wizard, sections, formatting, finalization.
Answer everything, then click Check: your score and explanations will appear.

1.1 · Recall

1. In the creation wizard, in which order do the founding decisions come?

Source + tables (and links), then fields, then groupings Totals first, details next Fields, then tables, then source last Page setup first, data next

The wizard chains source/tables with links, fields to display, groupings, then sorts/filters.

1.1 · Application

2. Farès prepares his sales report (date, customer, amount). Which tables should he keep?

Only Sales + Customers, linked on the customer ID All database tables, just in case Accounting and HR tables on top, to enrich No table, everything will be typed by hand

Minimum useful set: each table answers a wanted piece of information; links are checked before generating.

1.1 · Application

3. The wizard generated a raw report. What should Farès do?

Start over with all tables to be complete Remove the links, they slow the report down Treat it as a starting point: reposition, format, paginate (1.2 → 1.4) Send it as is to management, it is finished

The wizard report is a working starting point, to customize afterwards.

1.2 · Recall

4. What is the golden rule for placing fields?

Totals in Details to see them on every row Everything in Details, it is simpler Data in Details, headings in Page Header, title in Report Header, totals in Report Footer Headings in Details and data in Page Header

Each frequency has its section: per row (Details), per page, once (report).

1.2 · Application

5. Farès's grand total prints on every row. What happened?

The total is too big, the font must be reduced A table is missing from the report The printer automatically repeats totals The total sits in Details: move it to the Report Footer

Details repeats per record: a total belongs in the Report Footer (1×).

1.2 · Arbitration

6. Farès hesitates between a field object and a text object for “Invoice no. 2026-118”. Which call?

Combine in a single text object: “Invoice no. ” (fixed) + number field (variable) Create an extra table for this label Type everything as fixed text, with no field Put the number in the header and the label in Details

Fixed + variable combine in one text object: stable label, live number.

1.3 · Recall

7. What does a number format (decimals, symbol) change in Crystal Reports?

It automatically recalculates the report totals It converts currency at the daily rate It changes the value stored in the database It only changes display, not the underlying data

Format is presentation: calculations work on real values.

1.3 · Application

8. Farès's amounts show “1234.5” left-aligned. What should he fix?

Widen only the column headings Format “1,234.50” + symbol (properties, Number tab) and right-align Nothing, it is the financial standard Turn all amounts bold red

Decimals + separator + symbol via right-click → Format, numbers right-aligned.

1.3 · Arbitration

9. A field shows “#####” after formatting. Which call?

Disable the thousand separator for good Widen the field: the formatted value is wider than the raw one, then recheck in Preview Delete the field, the value is lost Change font to hide the problem

“#####” = field too narrow for the formatted value; widen it, do not degrade the format.

1.4 · Application

10. Farès finalizes his report before sending. What should it contain?

Pagination typed by hand page by page Only raw data, the rest is decorative The technical .rpt file name as the only title A title with period, “Page N of M”, the print date and repeated headers

Identified (title + period), dated and paginated automatically: each page reads on its own.

1.4 · Application

11. Farès's six columns overflow in portrait in Preview. What should he do?

Move all data into the Report Header Switch to landscape, adjust widths and margins, check nothing sticks out past the right edge Send it anyway, the printer will squeeze the columns Delete the column headings to save room

Wide report = landscape + tightened widths + right-edge check, verified in Preview.

1.4 · Arbitration

12. Column headings appear only on the first page. Which call?

Print the first page twice Copy them by hand onto each page of the PDF They sit in the Report Header (1×): move them to the Page Header (repeated) Add more special fields to compensate

Report Header = once; Page Header = each page. The section decides the frequency.

What's next?

Score ≥ 80%: move on to Level 2 V3 (sorts, groupings, totals, selection and parameters — calculations begin).
Score 50% to 80%: review the missed sections (minimum tables in 1.1, golden section rule in 1.2, number/date formats in 1.3, pagination and Preview in 1.4), reread the explanations above, then retake the test.
Score < 50%: restart the level by running each template (1.1 wizard, 1.2 placement grid, 1.3 presentation standard, 1.4 finalization check-list) — the 1.4 Preview is the judge: distribute only what looks clean there.