PurchaseOrderReportViewer Only Shows 99 Character for Item Overview

Trying to understand how to show all the characters in item overview when printing on PO.

Even though the item overview has max nvarchar when outputting on PurchaseOrderReportViewer only shows 99 character max. made sure the Can Grow is set to true as well.

Thank you!

Find more posts tagged with

Syteline Development

Accepted answers

All comments

Steve Poye

Were you able to address the issue, we have the same issue and don't know what to do.

unknown

Line 2183 of Rpt_PurchaseOrderSp trims it to 100 characters

nfelicioni

The stored procedure (Rpt_PurchaseOrderSp) limits the size of the item overview field to 100 characters. So you can write an extgen to remove the left statement, or modify the Report Viewer form to use form script to query the item using the IDO client to retrieve the entire Item Overview property.

Steve Poye

I assume then that in the cloud there is nothing we can do to fix this issue.

Steve Poye

An thank you very much for the reply

Steve Poye

Thank you very much for you reply I will try to change report viewer should be fun

rcostello

I think the easiest fix is to add a Load Collection to the StdObjectRefreshComplete event handler for the viewer form that sets the overview property back from the item master. The IDO is SLItems and the filter will be something like Item = 'P*Item'). I've done this and it works to fix this limitation.

Steve Poye

That does sound like something I can do it. Thank you very much!

Steve Poye

This worked thank you again RCostello!

Copyright © 2025 Infor. All rights reserved.