Alias in Crystal Report


I am working on a Crystal Report using the ODBC to link on my Progress tables. I want to create a Supplier Non-Conformance Report. Using these tables: NonConf, DMRHead, DMRActn, DMRCorAct, Reason, Reason_1, Reason_2.

I am able to add all the tables with no problem. However I am unable to use fields from any of my Reason table aliases. I get a pop-up with a Failed to retreive data message.

What I'm I doing wrong?

Thank you