Forum Discussion
Steg
Helper I
Helper IReport with (first) information from two separate tabels
I have two tables: a table names and roles (A) and a table with case numbers (B) Table A CaseID Name Role 1 John Applicant 1 Jim Applicant 1 Patrick Defendant 2 Emma A...
Steg , Join A and B on CaseID
Create a Matrix
Row -> B[CaseNr]
Column -> A[Role]
Values = Min(A[Name]) //you can use max/first/last too
amitchandak
Super User
Super UserSteg , Join A and B on CaseID
Create a Matrix
Row -> B[CaseNr]
Column -> A[Role]
Values = Min(A[Name]) //you can use max/first/last too
StegHelper I
Helper IThanks, works perfect.