I already tried to find an answer in here, please apologize if there's something similar already asked and answered.
Somehow I think I already did this before with JET, but can't remember how I solved it. Here is the problem:
I've two tables: table 1 has a number of rows that I want for the report (i'm using an NL function), and in table 1 there is a column "FK" that is a primary key of another table, table 2. In the options I select as a filter (with a lookup) the contents of a second column of table 2.
Now I want the NL function on table 1 to return the rows that satisfy the filtering done on the second column of table 2, using the link between the two tables with the common column "FK".
How do I do that automatically? I know that if I create a second filter in options with all the possible values of FK separated by "|" I could filter the NL function directly, but that's not I need. FK has dozens of possible values…
Please advise! Many thanks for your help.
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment I believe you would just use the Jet Link= functionality for this. For an example, see the "Simple Linking" Jet help topic at http://help.jetreports.com under the section "Reference/NL Function/Filtering Data/Linking to Other Tables Using Link=". Does that help?
Regards,
Hughes -
Jet Reports Historic Posts I think I used the Link= in the NL, but really need an example…
-
Jet Reports Historic Posts Yes, many thanks Hughes. I'm going to apply this. Cheers JL
-
Jet Reports Historic Posts It worked. I was putting the "Link=" to the second table first and then trying to filter by certain fields of the first table. Had to use the "Link=" and the second table filter as the last filter. Thanks for your help!
Please sign in to leave a comment.