Hi,
Im trying to create a report that lets me pull all the comments from the "Customer" table, however no matter what I try the report only puts "true" when a comment exists and "false" when no comment exists. I want the report to pull the actual text on the "customer" table. Is this possible?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello -
The "Comment" field in NAV's Customer table is a boolean (True/False) field:
I assume you are wanting to see the same comments as are accessible from the Customer card…
This information is actually stored in the Comment Line table…
Here is a rudimentary report that would list all customers in the database and all comments for each customer:
I hope that helps get you going in the right direction.
Please sign in to leave a comment.