Most of the selection rules you create in Crystal Reports use the And operator. When you use And, each of the values you specify must occur in a row for the road to be displayed. If you want to display a row if one of several values occurs, then you can use an Or operator. In this movie, I will show you how to create selection rules that use an Or operator.
- [Narrator] When you create a selection rule…using multiple criteria within Crystal Reports 2016…the program assumes that you want…both criteria to be true for a record to be shown.…For example that you want to see orders…for maintenance products that came…to the hotel in Cincinnati.…However you can also indicate that you want…to see orders where either of the two conditions are true,…whether it was an order from Cincinnati…or it was for maintenance products.…In this movie I will show you how…to create that type of selection rule.…
My sample file is SelectUsingOR…which you can find in the Chapter Seven folder…of your exercise files collection.…The first thing you need to do is create…a selection criteria that uses values…in two different fields.…So I will open the Report menu,…point to Select Expert and click Record.…Let's say that I want to go by PropertyCity…so I'll click PropertyCity and click OK.…And then rather is any value I will say is equal to…and then click the down arrow for the list control…on the right and I will click New Orleans.…
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: Create selection rules using the Or operator