Drilling Down on Data The purpose of creating groups is to organize a lot of data in a report so that the reader can quickly find their data by scanning through the different groups. This lets the reader skip over the data that doesn’t relate to them and instead focus on what is important. But […]
3.03 Adding and Customizing Groups
Adding and Customizing Groups Just like sort fields, multiple fields can also be used for creating groups. Each field is given its own group header and footer. An example of grouping on one field is a sales report that groups the sales people by their territory. If there are a lot of sales people within […]
3.19 Tutorial 3-3. Hiding and Suppressing Details
Tutorial 3-3. Hiding and Suppressing Details This tutorial walks you through the process of toggling the detail data on and off so that it can be drilled down into. Open the report Group Selection.rpt. This is one of the example reports installed with Crystal Reports. It is located in the Feature Examples folder. Right-click on […]
3.04 Tutorial 3-1. Creating a Grouping Report
Tutorial 3-1. Creating a grouping report To practice working with groups, let’s modify the Employee List report created in Chapter 1. That report listed each employee on a separate line. We are going to modify the report so that it first groups by the region and then by the city. Open the Employee List report […]
3.20 Summarizing Data
Summarizing Data A major benefit to grouping data is that it lets you put summary data within the group footer and header. This is beneficial because when there are a lot of detail records, you don’t want the reader to have to get out a calculator to calculate sub-totals and averages of columns. You want […]
3.05 Navigating Groups
Navigating Groups Adding groups to a printed report makes it easier to flip through the report and get a quick overview of the report’s information. But the Preview tab makes it even easier to work with groups. To the left of the preview window is the Group Tree window which lets you navigate to each […]
3.21 Tutorial 3-4. Creating Summary Fields
Tutorial 3-4. Creating Summary Fields This tutorial walks you through the process of creating summary fields that are displayed in the Group Footer. You will build a sales report that lists the number of purchases they had, their total sales and their average sales. Go to the Start Page and click on Standard Report Wizard. […]
3.06 Formatting Groups
Formatting Groups The default layout for groups is that they print one after the other. When the group footer is printed, the subsequent group’s header is printed right after it. Some reporting requirements require changing this default behavior. For example, an invoicing report is designed so that it is grouped by client and each client […]
3.22 Running Totals
Running Totals Running totals are like an advanced version of summary fields. They give you more ways of summing data and give you more flexibility for determining which data to summarize. The primary difference is that summary fields are calculated by group and running totals can be calculated many ways (by group, record by record, […]
3.07 Advanced Grouping Options
Advanced Grouping Options The majority of the time that you add a group to a report you just need something simple that displays the group name and sorts it in ascending order. This is the default behavior when you add a group to the report and nothing additional is required. But there are times when […]
