0

limitation of excel field size

Harald Leib

March 23, 2023 08:49

None

Follow

Hi all

How can i show the whole content from a field (text editor) in dynamics NAV (more than 256 characters) in a jet Report? Field size in excel is limited.

thanks

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  CascadiaDataworks March 23, 2023 21:51

  It's really a limitation of Excel and not something that Jet can override.

• 0
  
  Harald Leib March 27, 2023 07:44

  Thanks

  is there any workaround to get the whole content?

• 0
  
  CascadiaDataworks April 01, 2023 16:45

  There is, but there are some limitations. I will post how to do it next week (on PTO now).

• 0
  
  CascadiaDataworks April 03, 2023 16:35

  The challenge is that you will never know how many characters there are (unless there is a max value) and you will need to break that text into separate cells.

  You will need to create a NL("First") Record Key and then use Excel's MID function to break the NFs into chunks. You will need to decide what the starting points and number of characters to grab in the MID function and then also figure out what the max number of MID functions you will need.  I just used 5 characters for illustration purposes:

  

   

• 0
  
  Harald Leib April 11, 2023 13:09

  No, i'm sorry. It doesn't work with more than 250 characters. The max number of summary chrunks is still 250 characters. 

  Is it possible to read an decode a blob-file with jet reports?

• 0
  
  CascadiaDataworks April 11, 2023 14:11

  If the field is a BLOB field, you can only use NL("Blob") to read the field.  Ultimately, it seems like you have a bit of a complicated request and would probably best served working with a consultant.