Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export rpt with subrpts to txt file - single chr field not exporting

Status
Not open for further replies.

deb13

Technical User
Nov 20, 2003
49
GB
CRXI (BOEXIR2)

I have a report which has several subreports. The output of the report when exported is a text file which is then used as an import source for a unix application.

If a field in the subreport has only one character, it fails to export to the text file. However, a field with 2 or more characters exports to the text file perfectly well -

There are a lot of Y/N fields in the file so I need them to appear... I have tried moving the field in the report but this puts leading spaces into the text file and I need them to all be left aligned to the left edge of the text file...

The borders on the subreports are set to none.

This one has got me stumped. Any ideas please?

Thanks

Deb
Sheffield, UK
 
Sorry guys - thought I had done an exhaustive search but found the answer using a different search phrase in the following thread:


Good solution though - put a space after the fields where you know you are only outputting one character - easy if the field is hardcoded, not so easy if the field is a database field of indeterminate length...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top