From the course: SAP Business One: Reporting and Customization

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Add selection criteria parameters

Add selection criteria parameters - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Add selection criteria parameters

“

- [Instructor] You've selected a smaller subset of the production orders, but it would be a bit of a pain to change the selection criteria in your SQL query every time your wanted to run this. SAP Business One has a special code for SQL called parameters, which lets you easily make selection criteria like other reports. I'll make my report select status and a date range for production orders using parameters. So to change it and use this parameter I'm going to use a special function. And we're going to start here over on where and get rid of all this. Then I'm going to change it to T0.Status... equals and then this the parameter syntax. You put square brackets and then inside of it it's a percent and then the number for this parameter, and I usually start with zero and work your way up. So it'll be like this. Now this syntax only works with SAP Business One. It doesn't work elsewhere. So if you try running this…

Contents