Hi all,
I've developed a report that picks up some fields from the Item table.
I have an issue with one of these fields. This is the "Lead Time Calculation". The results is always "0" (zero). I have checked records with the fields populated (e.g. "2W" or "7D"), but Jet Reports always returns "0".
What should I do to fetch the Lead Time Calculation?
Thanks
Marco
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Hi,
this is the answer I got from Jet Reports support.
******************************************************************
I did some testing with various versions of C/Front and found that if I used C/Front version 3.10A then I would get 0 (or blank) from any field with a field type of DateFormula. The field "Lead Time Calculation" has a field type of DateFormula. If I use C/Front 5.01 or 6.0 then I get the correct results.
This appears to be a problem with C/Front and I would recommend upgrading to a newer version of C/Front. However to upgrade to a newer version of C/Front you will need to upgrade your Navision to a newer version.
****************************************************************** -
Jet Reports Historic Posts Hi Marco,
Which version of Jet Reports are you using? Alhough I'm not sure, I believe this is a "feature" of an older Jet Reports version.
I'm using Jet Reports 7.1.2 build 1826 and getting a date formule type of field is no problem at all. -
Jet Reports Historic Posts Hans,
I'm using Jet Reports v. 7.1.2 Build 1824 and Navision 3.10 with the propietary database.
I upload another test I did with the "Item Vendor" table. Attached you can see a NAV screenshot with some lead time, and the Excel file with the zeros.
ItemVendor.xls
Thanks -
Jet Reports Historic Posts May I recommend to contact the Jet Reports Support team. I have no idea why the date formula doesn't show in your report.
And may I ask you to keep us updated on the solution? Thx. -
Jet Reports Historic Posts I've submitted a ticket right now. I'll keep you updated.
Marco
Please sign in to leave a comment.