Hi Jet Reports Community,
I come from Germany and still working sporadic for about 8 years with JetReports. It is a great tool with which we do our complete reporting.
Now I have a little problem, which has not yet happened to me: I want to elicit the name of an address of a Navision database. The names are sometimes quite long. Unfortunately, the NL function shows only 30 characters. Why?
Rudi
=NL("First";"Address";"Name";"Address No.";$I15)
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello Rudi,
Your function looks great. Jet should return the entire field of information. Are you sure you are pulling the right field from within the table?
I don't have a table called Address so I can't check the details of it behind the scenes. I do know that I have worked with some NAV systems that have a Name field and a Long Name field. (Where Name displays only 30 chars and the Long Name displays 50.) Could this be the case for your system? -
Jet Reports Historic Posts Hello Kloser,
the table is called "Adresse". One field is called:. "Name (Adresse)" This field contains the name with 30 characters (eg "REWA Regional Water and Waste").
Another field is called "Name". This field contains the full name. (eg "REWA Regional Water and Wastewater Company Stralsund mbH").
It's probably the problem, which you're already encountered.
Why did'nt show me the NL-function=NL("First";"Adresse";J$14;"Adressnr.";$I16)
the full name? What can I do?
Rudi
Please sign in to leave a comment.