Could this be a height problem of the fields on the report? Might be worth just increasing the size a little to see.
Regards, Alastair. ----- Original Message ----- From: "Emmitt Dove" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 6:09 PM Subject: [RBASE-L] - Re: CSV report output > Bob, > > I just went into Concomp, selected the contacts by customer report, did the > text file setup (comma delimited), and printed to a text file. I obtained > the expected results. So in principle it works. > > My steps: > > 1. Open the report in the designer. > 2. Select File / Text file setup > 3. Specify the filename > 4. Select the file type as comma delimited > 5. Select the detail band > 6. Select all objects from the available list and move them to the selected > list > 7. Close the designer > 8. From db explorer, select the report and click Run > 9. Click on File under print target, click OK > 10. In the print to file section, select TEXT as the file type > 11. Click OK and it works. > > > >Emmitt, > > I am using V7 (updated this morning). This would be > >a resolution to my situation, except that for some reason, I cannot > >get a TEXT file to "work". When I output to a text file, it creates > >the file, but there are no contents. Size is 0. I have selected > >the controls under the Text File setup and they show as selected. > >(High lighted them under Available Controls and moved them under > >Selected Controls) > > > > If I print to a RTF format, it works fine, but not to a TXT format. > > > >I have at this time met my requirements by doing your second > >recommendation of creating a variable with all the columns and > >adding a comma between each. I then output to RTF and simply > >rename the file to a CSV extension. It seems to work OK! > > > >However, I would like to determine what I am doing wrong on the > >TXT format file or if it is something I need to submit to RBTI. > > > >Thanks for your input! > >-Bob > > > >Thompson Technology Consultants > >276 Chippewa > >LaPorte, IN 46350 > >219-324-2605 (Phone & Fax) > >219-363-7441 (Cell) > >http://ttc.inc.home.comcast.net > > > > > > > >-----Original Message----- > >From: Emmitt Dove [SMTP:[EMAIL PROTECTED] > >Sent: Tuesday, December 16, 2003 11:10 AM > >To: RBASE-L Mailing List > >Subject: [RBASE-L] - Re: CSV report output > > > >Bob, > > > >You don't mention which version of R:Base. If you're using 7, check out > >the Print to Text File Setup Options (on the File menu in Reports > >Designer). You can now use a v7 report to print a detail-only, fixed > >format text file or comma-delimited text file. Or, you can do what we do > >and build up a variable in code and then write the variable to a text file > >line-by-line. We use this for EDI exchanges with a logistics provider. > > > > >I seem to remember a thread about outputting a report to CSV format, > > >but I could not find it. > > > > > >I am writing an EDI application and need to create a CSV file. I know > > >I can EXPORT through Gateway, but it poses a particular problem. > > >I have to get one field of information from an accounting package > > >through ODBC. I have tried creating a view to include this info, but > > >the ODBC driver is so extremely slow, (this is not an Rbase problem) > > >it makes the file creation time unrealistic. Also, I have not figured out > > >how to turn off the column headings in the export file. (I tried Set Head > > >Off, but that did not accomplish the task) > > > > > >I can create a report, and use a lookup variable to the ODBC table and > > >the speed is fine! (Evidently, their ODBC driver does not handle views > > >very well. I did insure my linking columns where properly keyed) > > >However, while reports give me much more flexibility in creating > > >a data file, it does not have a CSV output format. > > > > > >Any ideas would be appreciated. > > > > > >Thanks, > > >-Bob > > > > > >Thompson Technology Consultants > > >276 Chippewa > > >LaPorte, IN 46350 > > >219-324-2605 (Phone & Fax) > > >219-363-7441 (Cell) > > >http://ttc.inc.home.comcast.net > > > >Emmitt Dove > >Manager, DairyPak Business Systems > >Blue Ridge Paper Products, Inc. > >40 Lindeman Drive > >Trumbull, CT 06611 > >(203) 673-2231 > >[EMAIL PROTECTED] > >[EMAIL PROTECTED] > > Emmitt Dove > Manager, DairyPak Business Systems > Blue Ridge Paper Products, Inc. > 40 Lindeman Drive > Trumbull, CT 06611 > (203) 673-2231 > [EMAIL PROTECTED] > [EMAIL PROTECTED] >
