Print View Problem - Select record if

Hi everyone,

I am trying to create a print report that shows a table view, but I can't get it to display the fields I want properly.

The table displayed is 'Shipping', and the fields shown below are showing correctly. However, I also want to display the column 'Journey' that shows whether the journey is a Collection or Return, and it will only show me the first, last, or concat. I want it to show the one that matches the date given. Any ideas please?

This is what I'm currently getting...