SAP Business One Crystal Report provide various function to ease developers reach their goals when developing report for the customers. For report which consist column and rows, table lookalike, with dynamic number of columns or rows, Cross-Tab provide much ease to development progress.
For example the query you have right now much or more can be illustrated like picture below
Highlighted Area are the important fields to be filled, also please take notice that each field responsible for one area, either Row, Columns or Summarized Fields.
Also read relevant SAP Business One Tips:
- Single Crystal Report Layout for A/R DP Request & Invoice
- Print Login User Name in SAP B1 Crystal Report
- How to Extend UDF Character Length in SAP Business One
- Run Query to Update or Insert Table when Create Document
- Display Table Info in SAP Crystal Reports
- Fix Error When Previewing or Printing Crystal Report
