May 05, 2014 07:48 AM|PatriceSc|LINK
Still unclear if not even more confusing.
The result image you shown doesn't seems to match the SQL request your first shown (for example you don't have any "Group Desc" column in the request you shown us while you have one in the result header).
I'm still unsure if the problem is that those columns are missing from the db or if you just can't show in your result page. Could you confirm the problem ?
Start perhaps with :
A.StartDistance As 'Start Odometer',
A.EndDistance As 'End Odometer'
Do you have an error ? If yes which one ? Or does it show the columns you expect ? Then add back the missing columns and test each time until you added back them all...
Or could it be that your output table (HTML ?) is truncated and that columns past End Destination are not shown at all for some reason ?
Keep in mind we don't have any other context than what you told us...