TextString limit in reports

scovillescoville Member Posts: 11
Hello

My report has a Comment field which has to gather all comments relating to a certain date and print them out in a single paragraph.

These comments add up to more than 2000 characters so I get a data overflow everytime I run the report with the Comment (Text) field.


Which type of variable should I use when printing Comments ?

Comments

  • WaldoWaldo Member Posts: 3,412
    When you use the default comment table, you should just use an extra dataitem (comment), and put the comment field in the "Body" section. So don't concatenate the strings, but just print it like seperate records... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • scovillescoville Member Posts: 11
    Thanks Waldo

    The table I am working with has seperate records for each comment line so it looks odd when I print each record seperately.

    Eg

    Record 1 - Sent the goods to the
    Record 2 - company

    I would like to put these two comments together so they read like one whole sentence.

    Is that possible ?
  • WaldoWaldo Member Posts: 3,412
    Yes it's possible, but I think it will take some coding ... . I did something similar in .NET and I bet it's also possible in Navision.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.