Try this go to concomp and take a look the form called Menuform. Goto Layout-Menu Designer-Contacts-Print Contact List
Find one you like and click Custom EEP Print reportname Option xls | Filename Reportname.xls| Open ON On 16 Dec 2003 at 11:32, Thompson Technology Consultan wrote: > 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] > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
