From the course: SAP Business One: Reporting and Customization
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Add selection criteria - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
Add selection criteria
- [Instructor] With our report looking good, it still is rather long and giving us a lot of data we really don't need. You can use conditional expressions to select the rows in your reports using the select expert. You can find the select expert either in the toolbar at the funnel icon or in the menu under Report, Select Expert. There's several types of Select, but I'm going to stick to Record. So go ahead and click that. Now I'm going to filter to just 2009 due dates first. So you're going to choose a field, and I'm going to go to the Due Date here, and I'll use that for my field, hit OK, and I get the Select Expert Record. You'll see you get a comparison over here, and if you look at them you got a whole bunch of different ones you can use. And this case, I'm going to use is between, and it'll give me two places to put a from and a to. If I click on the down arrow here, you'll see this is all the data that actually…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Create logic and calculation formulas5m 53s
-
(Locked)
IF, THEN, ELSE in formulas6m 3s
-
(Locked)
Conditional formatting3m 14s
-
(Locked)
Add selection criteria4m 56s
-
(Locked)
Use parameters for selection4m 56s
-
(Locked)
Sort a Crystal report2m 25s
-
(Locked)
Add groups and totals to a Crystal report8m 13s
-
(Locked)
Connect golden arrows in Crystal Reports5m 4s
-
(Locked)
Polish up the report3m 49s
-
(Locked)
Challenge: Make a sales summary49s
-
(Locked)
Solution: Make a sales summary6m 29s
-
(Locked)
-
-
-