Exporting out of BOE in flat file format
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17988
Printed Date: 03 May 2024 at 12:48am
Topic: Exporting out of BOE in flat file format
Posted By: dbodell
Subject: Exporting out of BOE in flat file format
Date Posted: 12 Nov 2012 at 2:16am
Hi. I know this isn't a Business Objects forum, but I thought I would ask here anyway. I have a Crystal report which has one long field in it. It is a concatenation of all of the fields I need for an "old style" fixed position flat file. In Crystal, when I export it as Record Format (columns without spaces) I get exactly what I want. However, it seems that BOE console does not have that option and when I export it as plain text, it is inserting a bunch of extra blank lines in between each of my records. Does anyone have any advice? Why doesn't BOE console allow you to export in any way that Crystal can?
-------------
Thanks,
D. Bodell
|
Replies:
Posted By: hilfy
Date Posted: 12 Nov 2012 at 11:10am
|
In your report, make sure that ALL of the sections that do not contain your one line of data are suppressed. Then try exporting to a text file. There may be some additional tweaking needed in terms of paper size to get it so that you don't get wrapping in the text field, but this should get you started. -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|