Level 4 exam — SAP Crystal Reports

Exam — fresh questions

12 questions to validate the level: subreports, charts, cross-tabs, SQL commands and multi-source, alerts and drill-down.
Answer everything, then click Check: your score and explanations will appear.

4.1 · Recall

1. What is the difference between a linked and an unlinked subreport?

The linked one shows the same data everywhere, the unlinked follows the record The linked one changes colors, the unlinked changes fonts There is no difference The linked one shows the data matching each main-report value, the unlinked shows the same data

The linked one connects via a link field and re-executes per value; the unlinked one is independent.

4.1 · Application

2. Farès places an invoices subreport linked in his customer statement. Where does he place it to preserve performance?

In a Customer group header or footer (once per group) In the page footer In the Details section, once per row In the page header

At group level: one execution per customer instead of one per row.

4.1 · Arbitration

3. The tables are in the same database and link cleanly through a key. Farès must show each customer's orders. What does he choose?

A classic join (the subreport is needless here) A linked subreport in Details Nested subreports Several cross-source connections

Same database + clean key = join, simpler and faster; the subreport is for non-joinable cases.

4.2 · Recall

4. In the Chart Expert, what do category and value represent?

Category = a summary, value = a group Category = often a group on the axis, value = often a summary as height Category = the font, value = the color Category and value are interchangeable with no effect

The chart turns the report groupings and summaries into a visual.

4.2 · Application

5. Farès wants to compare sales across regions. Which type does he choose?

A 20-slice pie A scatter plot with no axes A bar chart by region A line over regions

Bars compare categories; the line is for an ordered time trend.

4.3 · Application

6. What goes in cross-tab columns to keep it readable?

No dimension The few-valued dimension (months, categories) The many-valued dimension (hundreds of customers) All raw fields with no summary

Each distinct value creates a column: few values in columns, the many-valued one in rows.

4.3 · Application

7. Farès crosses sales by product and by month. How does he split the axes?

Customers in columns and products in columns too Everything in rows with no columns Products in columns, months in rows, with no value Months in columns (12 values), products in rows, total sales at the intersection

Many-valued rows (products), tight columns (months), summarized value + automatic totals.

4.4 · Recall

8. What is a SQL command in Crystal Reports?

Your own SELECT / FROM / WHERE / JOIN query as the source, executed as-is A change of report colors A slightly faster page sort A new chart type

Maximum control and performance: the database filters and aggregates, Crystal receives the minimum.

4.4 · Application

9. Farès writes a SQL command for the top customers of the chosen year. Which form is correct and safe?

SELECT * with no WHERE that fetches everything then filters in the report Query with a hard-coded password in the SQL SELECT with WHERE on the {?Annee} parameter and database-side GROUP BY, read-only account Query that concatenates user input into the SQL text

Parameterized filter + server-side aggregation, never concatenation or hard-coded credentials.

4.4 · Arbitration

10. Farès must combine the orders database with a non-joinable discounts file, on a large monthly volume. What does he do?

He recopies the file by hand each month He drops the discounts A multi-connection with client-side cross-source join A SQL command for the database + a linked subreport for the file (or upstream consolidation)

Different non-joinable sources = subreports; heavy recurring case = consolidate upstream.

4.5 · Application

11. Farès wants a regional summary with detail on click. What does he do?

He adds a filter on regions He hides the Details section (summary) to enable drill-down He exports to PDF then prints He changes the font of totals

Hidden details = summary; clicking a group expands its detail on screen.

4.5 · Arbitration

12. Management wants the dashboard both projected in a meeting and archived on paper. What does Farès decide?

Bet everything on ten alerts without checking detail Print the drill-down summary hoping detail follows Interactive version (alerts, drill-down, hyperlinks) for screen + detailed version for paper Deliver only raw detail with no summary

Drill-down does not print: screen for exploring, detailed paper for archiving.

What's next?

Score ≥ 80%: move to Level 5 — distribution, integration and best practices, and industrialize your expert reports (SQL views, summary cross-tabs, fair alerts).
Score 50-79%: review the missed sections (subreports 4.1, charts 4.2, cross-tab 4.3, SQL 4.4, interactivity 4.5), reread the explanations above, then retake the test.
Score < 50%: restart the level from 4.1, practicing each move (group-level linked subreport, Chart Expert, Cross-Tab Expert, parameterized SQL command, alert + drill-down), then retry the exam with a fresh mind.