1,771
Hi,
I want to print all comments on report by using GP report writer tool. But I could print only first 2 lines. Please help me to find solution to print all the lines on report. Please find comments and its report when I select 4 comments on report writer.
*This post is locked for comments
Hi,
This isn't going to be easy..
GP stores the Comments from SOP in the table SOP10106, but there are only 4 STRING fields to hold 50 chars each.. everything above (including the 4 lines) will be stored in a 500 chars TEXT field called CMMTTEXT (see below).
The text in that field is already concatenated with a blank between each line, which means you'll have to handle yourself the line wrapping.
| COMMENT_1 | STR50 |
| COMMENT_2 | STR50 |
| COMMENT_3 | STR50 |
| COMMENT_4 | STR50 |
| CMMTTEXT | TX500 |
If you want to add that to your SOP Blank form report, you may want to draw a field that is large enough to hold 500 chars.
Microsoft had published a KB article back in the days of GP 9.0 to extend the comment field to the entire COMMTTEXT data.. https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/how-to-articles/MSD_GPDisplayFourLineComment
PS; Mariano Gomez wrote a detailed blog post on the process back in 2012: http://dynamicsgpblogster.blogspot.ca/2012/05/adding-more-comment-lines-to-pop.html
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (