I have two tables (students, courses) which are related in an associative table (student courses). I have a unique compound key on the associative table, so I know there is only one occurrence for each student/course combination.

I need to create a 'crosstab' like table with the courses across the top and students down the left, with the completion date (field in student courses table) as the detail in the crosstab which can be saved as a spreadsheet.

Unfortunately, I can only summarize (count) the data, not display the 'date' data (completion date)

	Algebra	History
Bear, Yogi	1/1/18	6/1/19
Doe, Jane	2/15/18	1/15/16
Flintstone, Fred		2/5/17
Lewis, Rita	2/5/17
Smith, Bob	6/1/19	6/1/19

Here's what I've tried
1. summary field in student table, one field per course, using 'max' to get the date. This works, but I have 55 'courses' and I really don't want that many columns in the student table

2. created a new table using title of course as field name, then used automations to load the data. I run into issues with the merge, but I'm still playing with this to see if I can get it to work.

3. I'm also going to see if I can use connected data to solve???

Appreciate any hints or ideas on how to solve. Feels like I'm missing some really easy solution?

------------------------------
Thanks, CW
------------------------------

Forum Discussion

Crosstab report with data data

Report help

Summary Crosstab report

Summary Reports

Restful API Report digesting JSON

embedded reports