Ignition Report Help DB not returning values

I am connecting a report to an already established DB. The DB has a query established that workds (jde.LaborTransaction_ov). When I link this in reports and use the SQL Query Builder to map the paths, all is fine, but the linking does not return values as well as the key browser does not branch down to show the paths links. What could be wrong?

Can you share screenshots of the datasource config page?