Hello,
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.
Any ideas?
Thanks.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Ckyhl,
Can you upload your report please? -
Jet Reports Historic Posts I've changed it a bit and tried different things but it's essentially the same. I'm trying to pull in a joined field (from another table) into the report.
thanks. -
Jet Reports Historic Posts Sorry Chkyl, but I wouldn't know how to help you with this report. If none of the other forum members can help you either, I would recommend to contact Jet Reports Support.
I would appreciate it to learn how this is solved eventually.
Please sign in to leave a comment.