Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

(0) ShareShare
ReportReport
Posted on by

Hi,

I'm trying to find how to solve this issue in Nav 2013. Can anyone know how to solve this issue or guide me through the solution?

Regards,

Emmanuel

*This post is locked for comments

  • Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,116 on at
    RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    Did you found a solution for this?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    Hi,

    You can find out the reason with the help of debug that object.

    Debugging in NAV 2013 Client

    saurav-nav.blogspot.in/.../debugging-in-nav-2013-client.html

  • mmv Profile Picture
    mmv 11,467 on at
    RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    Hi,

    Could you post the screenprint?

  • RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    Hi,

    The big deal is no matter if I make a backup from the server database and restore it in my local PC the report filter works.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,911 on at
    RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    Do you get the error when you preview the report or as soon as you enter the filter, it looks like the issue could be in the report code itself which may not be executing in your local DB because of the data and in the other database where you experiencing error might has more data which triggers the custom code which is throwing the error ?

    Did you try to debug ?

  • RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    I am filtering the Item Ledger Entry table which it is a standard table. The Item Ledger Entry table has the Location Code field. That means every items entry records has a location code value. The length for this field is 10 in the table but regardless about this, I mention before that the odd things is when I try to do the same in my local database everything works fine.

  • Suggested answer
    jcastro Profile Picture
    jcastro 2,245 on at
    RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    Ok so I'm going to guess here.

    I noticed that the "Location Filter" in the Item table (and probably any other standard table that has the "Location Filter" field) has a length of 10. This means that if in your report you're the filter, it applies the filter onto a "Location Filter" field of a table (in order to calculate the inventory for example) during the execution of the report, you should get an overflow error like the one you're getting.

    Could this be the case?

  • RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    HI,

    The field I'm trying to filter is "Location Code" in a report for LS Retail Vertical. The odd thing is, I run the report in a local DB the report filter works fine. 

    I checked the report and there isn't any variable handling customizations for "Location Code" field.

    I use NAV 2013, 2013 R2, 2015 in my local PC. I think it might be a matter of hotfix or an upgrade missing in the client's machine.

    Regards,

  • mmv Profile Picture
    mmv 11,467 on at
    RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    Hi

    Could you post the exact error, perhaps the screenprint?

  • Alex A Profile Picture
    Alex A 2,348 on at
    RE: How to solve error filtering reports "The length of the string is, but it must be less than or equal to 10"

    Please detail the problem for us.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans