Using Crystal v8.5.
I am trying to export a set of data fields to a fixed length record, which totals about 450 characters in total.
I have created a formula for each field returning a string value of the required length for that field, I then put each formual in turn into a detail line. The visible output sometimes shows less characters than are in the field and sometimes it shows the right number. I am using the print/export/record style(no spaces) option. In the output there is sometimes one or two characters short, and sometimes the right number and sometimes an extra space or two. If I adjust the size of the field in the detail line then I can get exactly what I want but it is extremely difficult to adjust every field in this way.
Is there a way of causing what is actually in the data field to be in the output regardless of how it looks on screen.
I have tried concatenating the fields into two string values, this may just work but in creating the string variable with many concatenations each time I do anything with it crystal takes about a minute to actually do it.
I am trying to export a set of data fields to a fixed length record, which totals about 450 characters in total.
I have created a formula for each field returning a string value of the required length for that field, I then put each formual in turn into a detail line. The visible output sometimes shows less characters than are in the field and sometimes it shows the right number. I am using the print/export/record style(no spaces) option. In the output there is sometimes one or two characters short, and sometimes the right number and sometimes an extra space or two. If I adjust the size of the field in the detail line then I can get exactly what I want but it is extremely difficult to adjust every field in this way.
Is there a way of causing what is actually in the data field to be in the output regardless of how it looks on screen.
I have tried concatenating the fields into two string values, this may just work but in creating the string variable with many concatenations each time I do anything with it crystal takes about a minute to actually do it.