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 groups and totals to a Crystal report - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
Add groups and totals to a Crystal report
- [Instructor] We sorted the report into an order that looks good. But like SQL, a report would work an awful lot better with grouped information. You use the group expert to do that, then change some layout of your report. So in the menu, go to report, group expert. As you can see, there's also an icon for it, as you can see next to that. I'm going to just hit this and we're going to do this to O-W-O-R item code, and here it is. And I'm just going to group by that. And go ahead and click okay. Put yourself in design so you can see this better. You'll see there's little abbreviations on the side here but it's a lot easier to read in design mode. You'll see we've now added a group header one and a group footer one. Now you'll also notice up here, we've got group one item code. So it's got the title for the group here. And now, this item code here is redundant because we already have it up here, so I can take this…
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)
-
-
-