0

Difference in field name

Martin Emanuel

September 28, 2017 13:11

Answered

Follow

Hello,

I built a Jet Report accessing the "G/L Account" table.  In my report, I referred to field #34 which according to my Jet Table Browser has the name "Totalling" which I used in my NL formula successfully.  I then sent the report to a user and got an error message.  It turns out that the field name they have is "Totaling". 

In checking the details of the field via the Jet Table Brower, I have what I presume is a display name of "Totalling" and a field name of "Totaling". 

Is there a setting somewhere that controls how the field names are set?  I thought it might be a language problem but myself and the other user have the same language setup. 

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Martin Emanuel September 28, 2017 14:03

  In the screen below, in my Jet Report, I have to use "Totalling" but for the other user, they have "Totaling" as their description ...

   

  

• 0
  
  Harry Lewis September 28, 2017 15:02

  Hello Martin -

  The "display name" you mention is what Dynamics NAV calls a "caption".  While you can use captions in your Jet reports, it can cause issues if you distribute a report to a user who has different captions defined.

  Field names (in this case: Totaling {with one L}) will always work.  Likewise, you can also preface your captions/fieldnames with the field number.  

  For example:

  =NL("Rows","G/L Account","34 Totalling")

  and

  =NL("Rows","G/L Account","34 Totaling")

  and

  =NL("Rows","G/L Account","34")

  all give the exact same results.

• 0
  
  Martin Emanuel September 28, 2017 15:43

  Thanks Harry!

  I would prefer to use the actual field names to avoid errors like the one I'm experiencing.  Is there a way to force the use of field names instead of captions?  I'm at a loss to explain why the other user's Jet Report threw the error message and mine didn't. 

• 0
  
  Harry Lewis September 28, 2017 16:17

  In your data source settings, you can select how you want tables and fields to appear: