Advanced Crystal Reports 2011 Training Video

Create a Crystal Reports 2011 report from a blank report without the wizard, by connecting to an Access data source, selecting the right tables and fields, and arranging the layout.

Learn how to add and link multiple tables in Crystal Reports 2011, establish primary key–foreign key relationships, and configure joins to pull related data for comprehensive reports.

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.

Filter data in Crystal Reports by selecting a field and applying values or operators to reduce a large recordset, using equals, is between, is like, starts with, and compound filters.

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.

Learn to add and place summary functions in a Crystal Reports 2011 group report, summarizing monthly, state, and overall sales and net profit using group and report footers.

Apply conditional formatting using the highlighting expert to color and style fields based on values, such as days since last purchase, with multiple conditions and a preview of the result.

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.

Learn how to remove conditional formatting in a multi-condition report using the highlights expert, including removing individual conditions and confirming removals to revert to default formatting.

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.

Learn how to create a banded report in Crystal Reports 2011 by applying alternate row background colors using a conditional formula based on even record numbers to improve readability.

Use a summary field to color the group header by state total net profit, applying conditional formatting to highlight states above 10 million and above 50 million in green.

Create a new parameter field to filter data at runtime, define its numeric data type, and apply it via the record select expert to empower end users to control results.

Create a font parameter field with a predefined list, then use a formula to map the chosen font to the report’s format field for user controlled formatting.

Enable users to customize banded report colors through a color parameter, validate against allowed values, and adjust font color for black backgrounds to maintain readability.

This lecture demonstrates a parameter controlled sort in Crystal Reports 2011, allowing end users to sort by name, last sale, or net profit with a formula field and text conversion.

Explore how parameter masks control user input in Crystal Reports, using patterns like three letters and five numeric values to filter item refs, enforce formats, and reduce errors.

Set up and modify a report alert that triggers when stock drops to 1 or less, with an optional cost condition, and view the alert after data refresh.

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.

Drive alert messages with a formula in Crystal Reports 2011, dynamically composing text with current date and text conversion for alerts such as low stock, missing price, and weight items.

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.

Learn to use split sections to add a watermark background image to a Crystal Reports page by placing the image behind the page header and other sections.

Master column headings in drilldown Crystal Reports by splitting details into two sections, moving labels into details, and using suppress duplicates and suppress blank sections for clean, state-based drilldowns.

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 how to use subreports within a main report to display related and non-related data, filter subreports by detail sections, and build master reports.

Create unlinked subreports to summarize and display monthly sales data within a main report, using insert subreport, design considerations, and proper header placement.

Create and insert a linked subreport in the basket sales main report, linking via master and subreport fields to show only items sold per basket.

Learn to create on demand subreports in Crystal Reports 2011, enabling drill-down by clicking links and customizing on demand captions for linked or unlinked subreports.

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.

Discover methods to propagate subreport changes to the main report in crystal reports 2011, including re-importing via right-click and reinserting, or auto re-import on open.

Create and customize a Crystal Reports chart from a sales data set by placing it in the report header, selecting a year-based data breakdown, and tailoring the legend and labels.

Discover how to change chart types in Crystal Reports using the chart expert, exploring bar, line, area, pie, donut, and 3D options to improve data visualization.

Master chart formatting in Crystal Reports by editing chart type, labels, legend placement, fonts, colors, and axis options with the chart expert.

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.

Group states in a chart with the chart expert, creating specified order and alphabetic groups to improve readability, while keeping chart grouping separate from the report.

Explore how to apply top N in charts using crystal reports 2011, selecting top or bottom values, handling ties, and formatting labels to highlight the best selling products.

Place charts in group headers or footers to create group-specific visuals that filter by each data group. Copy from the report header, resize, and apply a group template.

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.

Learn to create and customize a pie chart in crystal reports 2011, showing a single data series as a percentage of the whole with legends, labels, and detaching slices.

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.

insert and configure a cross-tab in Crystal Reports to summarize data into a compact table; group rows by year, columns by month, and apply sum.

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.

Place cross-tabs into group headers or footers to filter data by group, tidy the layout, and display sales by month and year with responsive group headings.

Learn how to place multiple cross tabs in Crystal Reports 2011, manage their interactions, and use design tricks to prevent overlap while displaying monthly sales and profit.

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.

Master cross-tab reports in Crystal Reports 2011, comparing wizard-driven and manual creation, with data selection, year/month grouping, and month-name formatting via a calculated field.

Learn to convert crosstabs into charts, insert and customize charts from cross-tab data, and compare monthly and yearly trends with line and percentage charts.

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.

Declare a currency variable and compute a quarterly running total of sales in Crystal Reports 2011, using date closed and if statements to update Q1 through Q4.

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 how to alter a multi-pass formula to reset quarterly running totals by year, and configure evaluation time and reset logic for details and printing.

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.

Master exchanging data between a subreport and the main report in Crystal Reports 2011 by declaring and using shared variables to compute running totals and a grand total.

Discover how to create user defined functions in Crystal Reports, define parameters, and use custom functions to calculate age from birth dates and derive weekday names.