Report with (first) information from two separate tabels

Question

I have two tables: a table names and roles (A) and a table with case numbers (B)

Table A

Table B

I need to built a report that show per CaseID, the CaseNr, (first) Applicant and the (first) Defendant. Like this:

Is there an easy way to realize this report?

amitchandak · Accepted Answer

Steg , Join A and B on CaseID 
Create a Matrix
Row -&gt; B[CaseNr]
Column -&gt; A[Role]
&nbsp;
Values = Min(A[Name]) //you can use max/first/last too

Forum Discussion