I'm trying to retrieve information from a joined field and display it in a report. I've tried using the SQL function but I am having no luck. One of the columns that I am retrieving in my report is the row_id (join field) to another table. I want to retrieve information from that other table based upon the row_id that is in my report. I looked at the manual and tried to follow the example but this is not a great plains database. Here is the formula I am using:
=NL("SQL",$C$6, "NAME", "1S=PR_POSTN_ID", I6, "*")
Value of $C$6 = "SQL=SELECT DISTINCT NAME FROM S_POSTN WHERE %FILTER1%=ROW_ID"
The filter1 is the PR_POSTN_ID that I reference in the first line. The "I6" value is the cell that contains the PR_POSTN_ID value. I want to feed that value into my query.