Most of your data sets will have sets of common values. For example, you might have records with the same sales representatives, cities, states, or countries. Learn how to group your data using those values. Grouping your data within a report makes it easier to analyze the values it contains.
- [Instructor] Most of your data sets…will have sets of common values.…For example, you might have records that are broken down…by city, by product, or by product category.…In this movie, I will show you how to group your data…using those values.…My sample file is the Defined Group Report…and you can find it in the Chapter Four folder…of the exercise files collection.…If you want to create a group, go to the Insert menu…and then click Group.…In the Insert Group dialog box,…you can create your group here.…
First you need to select the field…by which you want to group your data.…So you click the top list box here.…The field list that appears contains two sections.…The first is the fields that are actually used…in the body of the report.…Those are on the top.…And then you have a complete list of fields at the bottom.…I'm going to focus on the fields…that are actually used in the report…and let's say I want to group by city.…So I'll click PropertyCity.…Next, I can select the order…in which those values will appear.…
We have in ascending order, in descending order,…
Author
Released
1/11/2017- Setting program and report options
- Changing the page layout
- Linking to a data source
- Adding fields to a report
- Creating sections
- Sorting and grouping data
- Formatting number, dates, and other fields and objects
- Adding charts
- Selecting records
- Managing reports with parameter fields
- Summarizing data with formulas and cross-tabs
- Adding subreports
- Exporting reports
Skill Level Beginner
Duration
Views
Related Courses
-
Learning Excel What-If Analysis
with Curt Frye1h 10m Intermediate -
Excel 2016: Pivot Tables in Depth
with Curt Frye3h 42m Intermediate
-
Introduction
-
Welcome1m 15s
-
-
1. Getting to Know Crystal Reports 2016
-
Set program options2m 17s
-
Set report options3m 45s
-
Assign report properties2m 5s
-
Navigate within a report3m 14s
-
2. Creating a Report
-
Link to a data source1m 59s
-
Add fields to a report3m 3s
-
Save a report3m 45s
-
3. Managing Report Sections
-
Create a section4m 38s
-
Resize a report section1m 46s
-
Merge report sections1m 29s
-
Manage section order2m 13s
-
Hide report sections1m 30s
-
Delete a section1m 47s
-
-
4. Sorting and Grouping Data
-
Sort data3m 48s
-
Define a group2m 21s
-
Reorder and delete groups2m 37s
-
Change group options3m 13s
-
Create a summary3m 7s
-
Define statistical summaries3m 50s
-
Create a drill-down report2m 54s
-
Sort by group2m 25s
-
-
5. Formatting Reports and Report Elements
-
Apply a report template1m 50s
-
Format a report control5m 10s
-
Apply formats to date fields3m 37s
-
Highlight records5m 48s
-
-
6. Adding Charts to a Report
-
Available chart types6m 1s
-
Create a chart3m 36s
-
Format chart elements5m 57s
-
-
7. Selecting Records in a Report
-
8. Managing Reports Using Parameter Fields
-
Allow dynamic parameters2m 52s
-
9. Summarizing Data Using Formulas
-
The Formula Workshop4m 38s
-
Correct formula errors3m 53s
-
-
10. Adding Subreports
-
Create an unlinked subreport3m 34s
-
Create a linked subreport4m 37s
-
Format subreports4m 13s
-
-
11. Summarizing Data Using Cross-Tabs
-
Add a cross-tab to a report3m 14s
-
Manipulate a cross-tab3m 12s
-
Sort cross-tab group values2m 50s
-
Format a cross-tab2m 57s
-
12. Exporting Report Data
-
Export to Excel2m 33s
-
-
Conclusion
-
Next steps1m 20s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Define a group