OUTPUT TRAILING SPACES TO A FLAT FILE

[PrgrmsAll]

We are attempting to output data to a fixed-width flat-file. The last column is a filler (no data) and MUST be sent to the text file. Somehow, Crystal is dropping the trailing spaces from each record which is not what we want.

Is there a way to FORCE the output of this filler/space?

Thanks in advance.

 

[chris777]

Just to clarify, you said it's a blank column that is not being exported, then you say Crystal is dropping the trailing spaces from each record. I just wanted to clarify which it is.

Also, can you include an example of the output and what you would like to see?

Thanks.


Chris
Data Intelligence Group

http://www.digus.com

 

[PrgrmsAll]

The column is has no data but has a length of 10. The output must reflect this blank data field. Therefore, the output could look something like this:

SMITH JOHN A9975559087 YNYYY |<END OF RECORD

After the YYY there is ten spaces reflecting the length of the last field. So far, Crystal is ending the fixed-width records after the YYY.

Hope this clarifies, thanks.

 

[Turkbear]

Hi,
Try this,if the field is truly NULL ( and not just a space or spaces), then be sure your Report Options are set to Convert Database NULL values to default. This should result in 10 spaces...Maybe...
OR,
Try creating a formula that evaluates to a 10 space string..and place this as the last field in the report.
( always specifying Fixed-width format of course)











To Paraphrase:"The Help you get is proportional to the Help you give.."