Thanks Razzak!! David
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, September 11, 2004 10:55 PM Subject: [RBG7-L] - Re: Printing Report to Text File > > David, > > Right. In that very specific case, you will need a separate report. > Just copy the original report and make all adjustments accordingly. > > Very Best R:egards, > > Razzak. > > At 10:43 PM 9/11/2004 -0400, David Blocker wrote: > > >Razzak > > > >No, you misunderstood. If you create a report in a small font with controls > >tightly set up to fit a lot of data on an 8/5" by 11" sheet of paper, even > >landscape, then if you print that report to a text file the fields are cut > >off. If you widen the fields to print to text ok, then the fields are too > >wide for the paper. > > > >So you WOULD in those circumstances need 2 copies. Right? > > ----- Original Message ----- > >From: "A. Razzak Memon" <[EMAIL PROTECTED]> > >To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > >Sent: Saturday, September 11, 2004 9:51 PM > >Subject: [RBG7-L] - Re: Printing Report to Text File > > > > > > > > > > David, > > > > > > No, you don't need to design a separate report. If there > > > is the possibility to print that report as plain TEXT, > > > all you need to do is adjust the fields to make sure that > > > nothing is truncated when printed as TEXT. > > > > > > It all has to do with fonts and spacing when printed as > > > plain TEXT. > > > > > > If the same report has to be printed as PDF, HTML and TXT, > > > you'll have to make sure that you test each printed format > > > accordingly and make all the necessary changes. > > > > > > In my sample report that I prepared for you to demonstrate > > > the difference, adjusting the width of CustPhone takes care > > > of everything. It also looks fine when printed as PDF, > > > HTML or XHTML (using version 7.5). > > > > > > Very Best R:egards, > > > > > > Razzak. > > > > > > > > > At 09:19 PM 9/11/2004 -0400, David Blocker wrote: > > > > > > >Thanks for the sample. Looking at your version vs. the original, I can > >see > > > >that in order to make this work you actually had to CHANGE THE ORIGINAL > > > >report to make the phone number control wider. If I read you correctly, > >in > > > >other words, for any report that a client wants printed to a text file, I > > > >would most likely need to create a SECOND version of the report for just > > > >that purpose, with wider controls. > > > > > > > >Have I understood you correctly? > > > > > > > >It does begin to beg the question - why would any client WANT to do > >this!! > > > >What would it gain them? > > > > > > > >From: "A. Razzak Memon" <[EMAIL PROTECTED]> > > > >To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > > >Sent: Friday, September 10, 2004 10:18 AM > > > >Subject: [RBG7-L] - Re: Printing Report to Text File > > > > > > > > > > > > > > > > > > At 09:40 AM 9/10/2004 -0400, David Blocker wrote: > > > > > > > > > > >I have tried the OPTION TXT in the Print command > > > > > >and also the ETXT option. TXT truncates, ETXT > > > > > >gives me an empty file. > > > > > > > > > > > > > > > David, > > > > > > > > > > Here's the tip of the day for you! > > > > > > > > > > 01. When you print the report as TXT or ETXT, as a > > > > > plain TEXT file, you need to keep in mind the > > > > > fonts, etc. > > > > > > > > > > 02. To print that same report as TEXT file: > > > > > > > > > > . Open the ContactsByCustomer in Report Designer > > > > > . Increase the width of ContPhone (DB Label) > > > > > . Save the Report > > > > > > > > > > 03. At the R> Prompt: > > > > > > > > > > PRINT ContactsbyCustomer OPTION TXT + > > > > > |FILENAME JUNK.TXT + > > > > > |OPEN ON + > > > > > |SHOW_CANCEL_DIALOG OFF > > > > > > > > > > What do you see? > > > > > > > > > > Do you see the phone number truncated any more? > > > > > > > > > > 04. FYI, when printing any report on Screen, Printer or > > > > > even PDF, all fonts are preserved and are displayed > > > > > accordingly. > > > > > > > > > > When printing the exact same report as TEXT, you as > > > > > a developer/user need to adjust the width, etc. > > > > > accordingly. > > > > > > > > > > In reference to printing the same report as ETXT, you > > > > > need to use Report Designer|File|Print To Text File Setup... > > > > > option. In this case, you need to select File Type, Bands, > > > > > and the available controls (DB Label, Variable Label, etc.) > > > > > to print as TEXT data. > > > > > > > > > > For your learning purposes, I have put together an updated > > > > > ContactsByCustomer report at: > > > > > > > > > > http://www.razzak.com/SampleApplications/ContactsByCustomer.zip > > > > > > > > > > Here's how to use this: > > > > > > > > > > 01. Simply unzip the file > > > > > 02. CONNECT ConComp > > > > > 03. At the R> prompt: > > > > > INPUT ContactsByCustomer.RPT > > > > > 04. At the R> prompt: > > > > > PRINT ContactsbyCustomer OPTION TXT + > > > > > |FILENAME JUNK.TXT + > > > > > |OPEN ON + > > > > > |SHOW_CANCEL_DIALOG OFF > > > > > > > > > > Hope that helps you understand! > > > > > > > > > > Very Best R:egards, > > > > > > > > > > Razzak. > > > > > > >
