0

Option Field Not Returning a Value

Jet Reports Historic Posts

February 05, 2009 19:02

None

Follow

I've tried searching for this particular issue so I apologize if it has already been addressed.

First of all, I'm using navision version 4.0 SP2 with a C/SIDE database.

Just trying to do a simple jet report to show me records from the Purch. Rcpt. Line table. Just your basic NL with several fields pulling in with the NF function. One of the NF fields happens to be an option field (Type). If the Type is G/L Account or Item that value is displayed just fine, but any time it encounters a line that has a type of Resource the value just shows up blank.

Tested this with other line tables as well and it will just not show Resource…it always comes up blank.

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts February 05, 2009 19:33

  Hi Dhamilton,
  
  Is the Resource option a customization? If I look into my standard NAV database the Type field in Purch. Rec. Line (table 121) has no option for Resource.

• 0
  
  Jet Reports Historic Posts February 05, 2009 22:10

  Yes, now that you say that I do believe it is a custom field. Can Jet handle when an option string has been modified?

• 0
  
  Jet Reports Historic Posts February 06, 2009 05:45

  Yes, Jet Reports can handle that, no worries. But you need to do something extra.
  
  Did you set up the language code in the Jet Reports Options? And a path for the langugae module? Jet takes the descriptions from that language module.
  
  The installation of Jet comes with a default language module based on standard NAV - I believe NAV version 3.7 W1. Which is pretty good, isn't it? But if you have a different version or customizations the language module may need to be updated.
  
  How to do that? The Jet Reports PDF document that you may download from the support site describes the steps very well (pictures included). Page 45 .. 47 describes the steps of exporting the language module from NAV after which your report should have the Resource description.
  
  Run this proces every time you get a customization on a table object (e.g. extra fields, new captions, new options). Thus Jet Reports will always have the same information.
  
  Please let us know how this worked out for your report.

• 0
  
  Jet Reports Historic Posts September 24, 2015 12:34

  Hi All
  I appreciate this is an old post but I started using Jet recently.
  
  I have customised the Location Table to include Location Type and Site Type. However when I pull this table it does not create the NAV_Options Tables with text and value parameters by default. Can someone kindly assist me with the documentation mentioned in previous posts and or with the process of getting this resolved. When I pull these option fields in a report, I only see integers 0,1,…5 instead of the actual values that I see in NAV.
  
  Any assistance will be greatly appreciated.
  
  Regards

• 0
  
  Jet Reports Historic Posts September 24, 2015 18:10

  If you are interested in learning how to export and import the language module, you can review this KB article:
  
  Navision Language Modules http://kb.jetreports.com/article/AA-00511/0/