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.
Next steps - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
Next steps
- [Instructor] Well you've done a pretty amazing job of going through a lot about SAP reporting and customization. There's a lot more you can learn, and you can go deep into many different topics including SQL. There are tons of courses in the library. All you have to do is put in SQL in the search bar, and you will find a ton of stuff. If you want to be careful, I would be going for stuff that either says Transact-SQL or Microsoft SQL or just a generic SQL. I'd stay away from some of the other ones like MySQL which don't fit a lot of the functions that we use in Business One. So that's one thing to take a look at. For Crystal Reports, know how to make connections and get tables and fields, that's what you really learned here. There's a lot of courses out there, the two really good ones that I would look at is in the library the Crystal Reports 2016 Essential Training and the Crystal Reports 2013: Linking, Nulls and…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
(Locked)
Use the Query Generator3m 2s
-
(Locked)
Open the Query Manager4m 5s
-
(Locked)
Change a query with SELECT, AS, and FROM6m
-
(Locked)
Debug a query4m 32s
-
(Locked)
Filter a query with WHERE5m 6s
-
(Locked)
Add selection criteria parameters4m 5s
-
(Locked)
Use SQL functions2m 50s
-
(Locked)
Sort a query with ORDER BY3m 29s
-
(Locked)
Make decisions with CASE4m 4s
-
(Locked)
Types in SQL3m 51s
-
(Locked)
Challenge: Sales report in SQL48s
-
(Locked)
Solution: Sales report in SQL4m 12s
-
(Locked)
-
-
(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)
-
-
(Locked)
Launch Crystal Reports1m 51s
-
(Locked)
Connect to the database2m 13s
-
(Locked)
Select and link fields3m 3s
-
(Locked)
Crystal Reports navigation3m 25s
-
(Locked)
Add fields to an existing report3m 52s
-
(Locked)
Format and layout a report4m 13s
-
(Locked)
Add text objects to a header3m 20s
-
(Locked)
Add graphics and color5m 48s
-
(Locked)
Challenge: Make a sales report1m 12s
-
(Locked)
Solution: Make a sales report5m 26s
-
(Locked)
-
-
(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)
-
-
(Locked)
Connect golden arrows in Crystal Reports6m 24s
-
(Locked)
Add a Crystal report to SAP B14m 45s
-
(Locked)
Modify reports and forms in SAP B15m 30s
-
(Locked)
Forms to SAP B13m 29s
-
(Locked)
Modifying legacy forms in SAP B16m 27s
-
(Locked)
Add a Crystal Report form to SAP B14m 42s
-
(Locked)
Challenge: Add a form45s
-
(Locked)
Solution: Add a form2m 58s
-
(Locked)