Create and apply Crystal Reports formula fields to calculate age, net profit, and days since last purchase, and to perform string manipulations like abbreviating names.

Override the database default sort in Crystal Reports by applying multi-level sorts—by last name, then first name, or by sale date and value—using ascending or descending options and formula fields.

Group data in Crystal Reports by fields such as state name, using the group expert to create group headers and footers, control sorting, and navigate grouped data.

Learn to create user defined groups in Crystal Reports using specified order, define expenditure ranges (small, medium, big spenders), and manage unmatched records with an others group.

Align the order of conditions in the highlighting expert to ensure later criteria don’t override earlier ones, using the priority option for multiple conditional formats.

Apply on/off conditional formatting in Crystal Reports using the format editor and formula workshop to suppress values and apply strikeout or drop shadows.

Apply conditional formatting in Crystal Reports 2011 to control font color and typeface by data values, using embedded if statements and color constants for multi-criteria formatting.

Learn editing, removing, and disabling conditional formatting in crystal reports 2011, use double slashes to comment out code and apply formatting to fields, test color changes when profit exceeds 5000.

Learn to create alternate page numbers in Crystal Reports 2011 by using conditional formatting to suppress left or right page numbers on odd and even pages.

Manage multiple alerts in Crystal Reports 2011 by creating, editing, enabling, disabling, and deleting alerts, then view triggered values and related records through the report alerts and triggered alerts.

Prompt users for numeric low stock and weight thresholds in Crystal Reports, drive alerts using these parameters, and customize messages to display the thresholds when items fall below them.

Learn to create and manage extra report sections in Crystal Reports by inserting, suppressing, merging, and deleting page headers, details, and footers to control their order.

Split the page header and footer to display different content on odd and even pages, using the section expert to add a logo, file path, and date with conditional suppression.

Create a continued state label in the page header for multiple page groups by comparing current and previous state names with a formula, and conditionally suppress blank headers.

Learn to hide empty subreports by suppressing blank subreports and conditionally suppressing the main report, report headers, footers, and subreport sections when no data is present, saving page space.

Split report sections to prevent overlapping subreports, placing subreports in separate header and detail sections so each can grow independently without interaction.

Explore creating charts with multiple data series in Crystal Reports 2011 by deriving sales year from the date closed and formatting month labels and dollar values per year.

You can place multiple charts in a Crystal Reports 2011 report by using resizable rectangles, copying and pasting charts, and fine-tuning titles and legends for side-by-side layouts.

Create multiple pie charts to compare year-by-month sales by using a month formula field and month name, enabling proportional year comparisons across 2010, 2009, and 2011.

Convert month numbers to names in the cross-tab with a month name formula, keeping order. Swap headings, customize names with a formula, and trim with left for a cleaner layout.

Master cross-tab totals in crystal reports 2011 by showing, moving, or suppressing row and column totals with the crosstab expert and customizable style.

Format a cross tab with the cross-tab expert and predefined styles, customizing fonts, colors, and background for rows, columns, and totals without altering the underlying data.

Apply conditional formatting to a Crystal Reports 2011 cross-tab to highlight values with color, bold, and font changes for monthly totals and cross-tab fields.

Sort a crosstab by its summarized data using the group sort expert, selecting top or bottom values (sum of line total) and applying top N or top percentage options.

Explore how to adjust cross-tab calculations in Crystal Reports—switch between sum, average, count, and more—and display results as percentages of the total, row, or column.

Use a parameter and a conditional formula to let users group cross-tab reports by item, month, county, or brand. The prompt setup updates the cross-tab according to the selected grouping.

Learn how to apply multiple grouping to cross-tabs in Crystal Reports 2011, organizing data by state and city or by year and month, with logical field order and clear readability.

Declare and type variables in Crystal Reports formulas, assign values, and use them in your report to compute totals like current price times quantity with semicolons.

Explore how Crystal Reports uses multi-pass reporting to read data, run flat formulas before reading records, build crosstabs, and later use saved data for grouping, totals, and page counting.

Learn to output multiple variable values from one formula in Crystal Reports 2011 by concatenating Q1 and Q2 outputs, with running totals and year-end resets.