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

Add selection criteria - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

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…

Contents