Skip to content
+1-888-319-3663

COMMUNITY FORUM

Report Writer field too long

Althea-ADSBI asked 8 years ago
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
Answers
Best Answer
Nicole answered 8 years ago
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.
Althea-ADSBI replied 8 years ago

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.