Max allowed text length in a text box within Report section

DeSp
Member Posts: 105
What is the max allowed text length in a text box within Report section?
It seems to me that it is not 1024 as for the TEXT data type. Am I right?
Thanks in advance.
It seems to me that it is not 1024 as for the TEXT data type. Am I right?
Thanks in advance.
Nil desperandum
0
Comments
-
1024 is the limit of a text variable, if it is a table field then it is 250.0
-
I have a text box in a report section. This text box is sourced from some text variable (Length=1024). When a report tries to display this section Navision crashes. The max allowed length not leading to a system crash for this variable is 404. Is it a normal behavior?Nil desperandum0
-
Dear Friend,
Navision allows 1024 as max length in report and my report is running fine. There must be some other problem.CA Sandeep Singla
http://ssdynamics.co.in0 -
Ok, here is what I do:
1. Create a new report with a Customer dataitem (for example).
2. Fill in the code:Customer - OnAfterGetRecord() [ FOR I:=1 TO 405 DO // I is a Local integer variable TextVar[I]:='A'; // TextVar is a Global TEXT (Length=1024) variable ]
3. Create a section with a Text Box sourced to a TextVar variable (SourceExpr=TextVar)
4. Compile, Save and Run a report.
5. Enjoy your Navision crash (EventType: navisioninternalerror P1: navision P2: 03.70.01.16172 P3: 8 P4: 24)
This issue was reproduced on different clients, different reports, different databases with Navision 3.70A and 3.70B SQL and single user versions.
Any suggestions would be appreciated.Nil desperandum0 -
I don't have my list of internal errors, but I think your error is either
error 8 in module 24
or
error 24 in module 8
Maybe someone else will be able to find the error text before I get back to my other machine and find it for you.
T0 -
I guess it is:
24-8 Internal Errors #Err_MT_RecordTooLong (Module_MT,8 )
But what does it mean?
Have anyone else experienced such a report section TEXT length issue?Nil desperandum0 -
I ran the report in 4.0 sp2 and sp3. No crash. in 3.7 it crashed. So upgrade the executables.0
-
Thanks for your help, ara3n.Nil desperandum0
-
you are welcome. I would suggest to move to sp3. It will save you a lot of security issues if you are on sql.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions