I have a report that I am modifying. I only added the "Shipment Type" criteria and it works for shipment types containing numbers (1,2,3,4,5,6,7,8) but when it gets to a type that contains a letter (I, J, T, D) it fails with a #Value error that I can not explain? All codes listed are in the DB. If I run the "debug" it tells me "10 is not an option. The exisitng options are ,1,2,3,4,5,6,7,8,I,J,T,D" which seems to include what I am asking for to begin with? Any ideas, anyone?
=NL("Count","Shipment",,"Company=","10-COMPANY1","Date Created","010112..013112","Cust. Reg. Type Code","COMMERCIAL","Shipment Type", "J")
Date
Votes
1 comment
-
Jet Reports Historic Posts Hmmm, so this is very strange. Basically when Jet filters by an option value using C/Front it specifies the option index. So 10 would be the index of the "J" option. But for some reason NAV itself is complaining that this is not a valid index and I'm not sure why that would be. Maybe because the options themselves are all mostly integers and NAV is getting confused about whether the 10 we're specifying is supposed to be an index or a value. I'm just not really sure. It could be an issue in either NAV itself or in Jet. You should probably send this through Jet support so someone can look at the problem in more detail with you.
Regards,
Hughes
Please sign in to leave a comment.