PS/Query Problem

[westiex2]

I have a text box in a panel that will allow the user to input carriage returns at the end of the line or they can let the line wrap.

The problem comes when PS query tool encounters a carriage return - it stops returning results at that point.

This field is the header notes for an invoice. I need to be able to extract this data via an expression or something and put it in the header notes field(s) on the invoice.

Any help would be greatly appreciated.

 

[johnmanfreda]

Hi West,

What data type is the field you are storing the text box to in PeopleSoft? If it is a text field then you may have to return a substring function from the database in an expression this is a rather ugly solution in crystal. If you can change the storing field to a long data type. This is availible in oracle then it should be a piece of cake to return that in query and/or crystal. Hopefully you can use the long data type to solve this problem.

Hope this helps,

John