I have the following fields on a report:
Institution
Personal_ID
Caption
Caption_Value
My report looks like the following:
Institution Personal_ID Caption Caption_Value
1 1 Tickets Yes
1 1 Refereed Yes
1 1 Bike No
1 2 Tickets Yes
1 2 Refereed Yes
1 2 Bike Yes
Is it possible to create a report that looks like the following:
Institution Personal_ID Tickets Refereed Bike
1 1 Yes Yes No
1 2 Yes Yes Yes