Good day.
I have a report that is used to generate a plain text file that is suitable for direct import into either Microsoft Access or Microsoft Excel.
Since the upgrade to Alpha 5 v7, I am encountering a problem with the output format: it is no longer tab-delimited.
The report is optimized for export and has been stripped of headers, footers, and anything else extraneous. I am only concerned with the detail record on each line of the report.
The report is more useful than a direct export of the table, since the report includes a variety of calculated fields that are not stored in the underlying table.
I use a simple snippet of XBasic code to perform the function:
query.filter = ""
query.order = ""
:Report.saveas("XReport","TEXT",query.filter,query.order ,"C:\XDirectory\XReport.txt",.t.)
When performed in v6, the output file XReport.txt contains tab-delimited data from XReport.
When the same code is used in v7, the output file XReport.txt contains space-padded data from XReport. The result is not fixed-width but highly variable from line to line.
The space-padded file is unusable in either Excel or Access.
When I run the XBasic code, I notice that under v7 the XReport.txt is sent to Alpha Five Printer, whereas under v6 XReport.txt is sent to Text Driver.
One further test confirmed that the v7 Alpha Five Printer is the source of the changed output results.
I re-installed v6 on the same PC with V7, and then manually printed XReport to v6 Text Driver printer from within V7.
The XReport.txt was tab-delimited.
How can I restore the capability to export a report to a tab-delimited Text File under v7 and without maintaining a v6 install?
Thank you in advance for any comments or suggestions.
John Cupak, Jr.
I have a report that is used to generate a plain text file that is suitable for direct import into either Microsoft Access or Microsoft Excel.
Since the upgrade to Alpha 5 v7, I am encountering a problem with the output format: it is no longer tab-delimited.
The report is optimized for export and has been stripped of headers, footers, and anything else extraneous. I am only concerned with the detail record on each line of the report.
The report is more useful than a direct export of the table, since the report includes a variety of calculated fields that are not stored in the underlying table.
I use a simple snippet of XBasic code to perform the function:
query.filter = ""
query.order = ""
:Report.saveas("XReport","TEXT",query.filter,query.order ,"C:\XDirectory\XReport.txt",.t.)
When performed in v6, the output file XReport.txt contains tab-delimited data from XReport.
When the same code is used in v7, the output file XReport.txt contains space-padded data from XReport. The result is not fixed-width but highly variable from line to line.
The space-padded file is unusable in either Excel or Access.
When I run the XBasic code, I notice that under v7 the XReport.txt is sent to Alpha Five Printer, whereas under v6 XReport.txt is sent to Text Driver.
One further test confirmed that the v7 Alpha Five Printer is the source of the changed output results.
I re-installed v6 on the same PC with V7, and then manually printed XReport to v6 Text Driver printer from within V7.
The XReport.txt was tab-delimited.
How can I restore the capability to export a report to a tab-delimited Text File under v7 and without maintaining a v6 install?
Thank you in advance for any comments or suggestions.
John Cupak, Jr.
Comment