group by id

I have a table

that gets messed up if I try to change Model Behavior from Basic to Aggregate but I do want to group by CR__r.Id

Any suggestions?

Group by CR__r.Id,  and by the other fields in your table.  Since these are all the same you should only get one row in the table per CR__r.Id. 

Can you post a screenshot of the “Messed up view”