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:
- Locking Report Design in SAP Crystal Reports
- Sending Documents via Email with Document Printing
- Enable Address ID Updates for Business Partner in SAP B1
- Set Default Price List Separately from Payment Terms in SAP Business One
- SAP B1: Control Who Can Remove Sales Opportunities
- Rearranging Item Lines in SAP Business One Transaction Documents
