Composite Matrix

 Composite Matrix: Aggregate multiple reports into one place and also we can perform complex calculations such as row calculations column calculations.

Composite report Is only report we can create based on the business object. All other reports we can create based on data source.

Scenario 1:

1.

2.

3.

4.

5.

Scenario 2:

1.

2.

3.

4.

5.

Scenario 3:

1.

2.

3.

4.

5.

6.

Call Scenario 1:

Now create Composite Matrix

Rules: Common field,Business object, Control field.

1.

2.Control field: Common group by expression  of  of your sub report.

3.

4.

5.This is place we can call sub report into this.

6.

Call Scenario 2:

7.

Call Scenario 3:

8.

Output:

Scenario:4

mlmm

Insert column:

Look up field:

We can create 4 variables in footer/header section in Composite matrix.

No web service option in composite matrix.

web service option in advance and n search.

Coposite matrix can't give access directly to users. First we will provide sub report access to users.