SAP B1 Advanced Reporting

If you know the basics of SQL and Crystal Reports, here’s more extended learning for you. We’ll cover subqueries in SQL and Subreports in Crystal reports as we build a production order that includes routing data.

Introducing routing

SQL Tables for Routing

SQL Subqueries

Crystal Report Subreports

Returning values from subreports

Appendix A: Left Outer join

The power of LEFT OUTER JOIN is an alternative to subqueries. In this article I’ll explain how they work. Video coming soon.