I am working on a SSRS report that's been developed by someone before me. The query pulls everything that I need it to except for the data off a table called "legheader". I have played around with joining the legheader a different way (inner join) and joining it to a different table. No matter what I try, I am either left with the same issue or no data completely.
Here is some sample data. You can see "trip number" and "driver" is not being populated:
Here is the query for the dataset:
Here are some relationships for the tables:
