I am trying to select a list of "Guardians" only for "Students" with a "School Year Code" 09/10 or 10/11. The "Students" and "Guardians" are stored in the "Customer" table, and the relationships between students and guardians are defined in the "Student Guardian Relationship" table.
I would have anticipated being able to use the following LINK function to return the desired records: (using count instead of rows for testing)=NL("CountUnique";"Student Guardian Relationship";"Guardian No.";"Link=";"Customer";"No.";"=Student No.";"School Year Code";"09/10|10/11";"Type";"Student")
…but this functions returns all the "Guardians" in the "Student Guardian Relationship" table.
Too check my sanity I used the following filter function:=NL("CountUnique";"Student Guardian Relationship";"Guardian No.";"Student No.";NL("Filter";"Customer";"No.";"School Year Code";"09/10|10/11";"Type";"Student"))
…this function returns the correct set of records.
This is already a solution, but I would like to improve my understanding of Jet. Can someone explain to me why these to functions returns different results? Thanks in advance.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello,
I'm not seeing anything wrong with your formulas, they should return the same result from what I can tell. Did you run the report by hitting "Report" or "Refresh"? Some formulas are optimized in Design mode, and will not return the correct result until the report has been run.
Link= is typically faster, but that depends on the size of the filtered record set. If running the report does not help, please log a support case on the Jet Reports support site (http://support.jetreports.com).
Regards,
Please sign in to leave a comment.