In the previous movie, I showed you how to use the if-then structure to decide which of several sets of instructions to follow based on a report value. Now learn another way to select which set of instructions to follow by using the case structure. The case structure is perfect for defining conditional actions based on multiple conditions.
- [Instructor] In the previous movie,…I showed you how to use the If/Then structure…to decide which of several sets of instructions…to follow, based on a report value.…In this movie, I will show you another way…to select which set of instructions to follow,…by using the Case structure.…My sample file is the Case Report,…and you can find it in the Chapter Nine folder,…of the Exercise Files collection.…The If/Then structure allows you to make…one of two choices; if something is true…then do something, or, if the condition is not met,…for example, an order is not greater…than 250 dollars, then do nothing.…
If you want to have multiple possible actions,…then you can use a Case Statement, to define those actions.…To start, I need to create a new formula field.…So, I'll go over to the Field Explorer,…which is at the right side of the program window.…If you don't see the Field Explorer, then go to…the View menu, and click Field Explorer, to display it.…Mine's already visible, so I'll click…Formula Fields, and then click New.…
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: Add case statements to formulas