Summary

In this chapter, we discussed two main areas of SAP Business One reporting tools to increase the query's usage. You learned Query Print Layout Designer and Command for Crystal Reports.

By using these tools, you can generate user-friendly reports.

Query Print Layout Designer (QPLD) has the advantage of being used quickly whenever you need to show your query results in a consistent manner using your favorite style.

You learned how to create, edit, and delete QPLD.

Command for Crystal Reports ensures that the query can be the kernel for a Crystal Report with no need to worry about the complicated links if you build the report from multiple tables directly.

You leaned how to create data connections. Last but not least, you learned how to add Command ...

Get Mastering SQL Queries for SAP Business One now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.