Creating a matrix report

Matrix report!!! This word suggests complexity. In reality, it's not that tough. In this recipe, I tried to keep it as simple as possible.

How to do it...

1. Create a new report from Object Designer.

2. Create global text constant with the following details:

   Name	ConstValue
   ReportNameLbl	Item by Location

3. Add the following lines in the Report Designer:

   Data type	Data source	Name
   DataItem	Location	<Location>
   Column	Code	Location_Code
   Column	Name	Location_Name
   Column	ReportNameLbl	ReportName
   DataItem	Item	<Item>
   Column	"No."	Item_No
   Column	Description	Item_Description
   Column	Inventory	Item_Inventory

4. After making the previous changes, Report Dataset Designer should look like the following screenshot:

   

5. Set the following property for the Location data item:

   Property	Value
   DataItemTableView	SORTING(Code) ORDER(Ascending)

6. Set the following property for the Item data item:

   Property	...