Most DataFlo reports have now been converted from PROC to Report Manager, including a large number in releases as early as 5.5.x. While these procedures are still using essentially the native Retrieve language of Universe and UniData, most of these reports now have an Export capability. This EXPORT feature actually uses the wIntegrate Import/Export facility under the covers. This feature of Report Manager provides the ability to export the data from the DataFlo application data files directly to a variety of PC file formats, including EXCEL.
To use the EXPORT feature, simply fill in the report options as you normally would. Then, at the command prompt of the report screen, simply type the word EXPORT. This option brings up another screen that allows you to specify the following:
- Output Format (e.g. XLS)
The type of file you would like to create, e.g. XLS for an Excel worksheet.
- Export File Name (including the file network path)
- Overwrite data file option (Y/N)
Overwrite existing file on PC/network.
- Include Field Descriptors (Y/N)
Include column headers
- Explode Values option (Y/N)
- Repeat Data option (Y/N)
Repeat single value fields when related to multi-valued fields.
In addition, you can specify which data fields to include or exclude in the EXPORT. Note that the EXPORT feature is not enabled for all reports -- those DataFlo Report Manager reports that use a basic program to display calculated data fields do not have this feature.
UniData, UniVerse, and wIntegrate are products, copyrights and trademarks of Rocket Software
DataFlo & Report Manager are products, copyrights, and trademarks of Epicor Corporation