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.
Group data with GROUP BY - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
Group data with GROUP BY
- [Instructor] From the production report we have now, let's scroll down, you'll see we have a lot of the same products for production. The product available does not give us a good sense of how much components we really have and how much we need in order to make. For that we need to total some numbers. So, what I'm going to do is I'm going to make a copy of this current report. And the best way to do that is first of all, to just save as, go to develop and test, I'm going to save the production report draft again, and hit save. It'll tell me, a query name exists with this category, replace it? I'm going to go, yes. I've now saved it properly, the way that this one is. So that's good and saved, I can close this one up, which I won't need. Go back into query manager, and then I go back and develop and test here, and pick up another copy. And then I'm going to do the same thing all over again. Save as,…
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)
Plan your report with good questions2m 5s
-
(Locked)
Add comments for readability4m 14s
-
(Locked)
Text editors with SQL2m 38s
-
(Locked)
Date and string functions6m 13s
-
(Locked)
Handling NULL values4m 58s
-
(Locked)
Use INNER JOIN for two tables6m 5s
-
(Locked)
Use JOIN for multiple tables5m 47s
-
(Locked)
Group data with GROUP BY5m 27s
-
(Locked)
Use aggregate functions5m 11s
-
(Locked)
Challenge: Sales report with BP info42s
-
(Locked)
Solution: Sales report with BP info5m 3s
-
(Locked)
-
-
-
-
-