Report Writer field too long
We were able to print our new SOP Header eXtender field on our SOP documents. However it is a 255 character long string field and Report Writer is limited to 80 characters. There are already instructions for parsing out SOP Comment lines from 4 to 9 and we have done that in the past. But they use a build in RW function RW_SOPCommentText that was made for that purpose. Is there anyone out there that has parsed a long string eXtender field into 4 lines of 80 in Report Writer? They need all the info from this field on all SOP docs. Any guidance is greatly appreciated! Thank you, Althea
There is a RW_substring function in Report Writer to grab certain portions of a field. The problem is that you have to first create a calculated field using the rw_tableheaderstring function to get the Extender field into Report Writer. When you do this function, it chops off the field to the 80 characters so then the rw_substring function doesn’t do anything for us. There isn’t a function in report writer that we can use to grab the whole field from Extender unfortunately. With that being said, there really isn’t a way to pull all 255 characters from an Extender field into Report Writer. If you have Extender Enterprise, a workaround might be to have the long string field on your Extender window and then create 4 additional fields on the window that use GP scripting to substring out the Long String field into those 4 additional fields. You could hide or disable these fields if you want. Then you would just use the additional fields in Report Writer. You cannot do it with a calculated field because those cannot be pulled into Report Writer.
Thank you so much, Nicole. I have created the 4 addit fields and hid them. Do you have a sample GP scripting to substring out the long string field to those 4 additional fields?
If you would like to submit an answer or comment, please sign in to the eOne portal.