HELP...

I am looking to export a Fixed Width Text file using Crystal Reports. However, Business Objects does not provide for more than around 250 characters.

Anyone have a solution so that I can export directly to a text file from Crystal with a total of 500 characters....?

Thanks

Crystal does a lot of things very well, but sounds like you are running into one of it's limitations. This might would be one situation where want to look at alternatives to Crystal (ie pl/sql or t-sql, etc) to accomplish this. What is the export being user for? Is it being used to interface to another app?

Communication with a vendor... Insurance census and enrollment fields, payroll files, etc.

I just published a Crystal report that truncates when I run it from the LRS server. Is that a result of this 500 character limit too?

Sure is.... Business Objects told me that text files are outdated technology that is not being used. However, there is a number of questions about this on the Crystal Report Forum of their website.

There has to be a solution because one post says that if you reduce the font size it works. However, when I reduce the font I do not get any information.

Are you looking to export your 500 characters all into one row? If you don't mind it wrapping, it can be exported that way...no matter what your font size.

It needs to be in one row for the vendor.... (No wrapping)

Thanks
Shane

There is a program in $GENDIR/bin called 'cnvexp' that we use for changing the 1099 files to fixed length. Try using that on your file, i.e. cnvexp -f filename 500 > outputfile