Hello,
Please, what do you see wrong with this formula?
B16 ="-=NL(""SUM"";""Sales Line Archive"";""Amount"";""Sell-to Customer No."";"""&$G$4&""";""Document Type"";"""&$G$5&""";""No."";NF(;""No."");""Link="";""Sales Header Archive"";""No."";""=Document No."";""Order Date"";"""&$D$7&""")"
G16 =NL("Rows=7";"Sales Line Archive";"No.";"Filters=";$F$4:$G$8;"Link=";"Sales Header Archive";"No.";"=Document No.";"Order Date";$D$7;B16;"*")
With Design mode it shows values, but when running the report it comes up with this error (I'll give you an approximated translation since it's not shown in English) - "Dynamics NAV C/Front reported the following error: The field with no. 0 is not defined within the Sales Header Archive table."
Thanks,
Elena
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Elena,
You can't sort inside a Link=. You should move your filter for B16;"*" before the Link= in the NL(Rows) function. Does that help?
Regards,
Hughes
Please sign in to leave a comment.