Export Formats

[Bruce_Gardner_(Guest)]

Hi:____Our client is very interested in e-mail bursting to send their salespeople their quarterly reports.____I^ve looked at the Export options & found:____-PDF not currently available__-HTML columns do not line up correctly (tho^ the actual report is OK) ->looks unprofessional__-RTF columns are lined up but no Page Headers or Footers appear____We are currently using version 9.0.009.____What is the best way to send a report as a professional looking attachment using e-mail bursting?____Thank you.

[rickwjohnson]

Bruce, you have hit the $64 nail on the head. There is no good way. I almost gave up on trying. ____However, I eventually got around this by creating .PDF files (must have R&R Ver 9) into a folder. Then, I use visual dbase to open Outlook(Using OLE) and move the files to an email (the files are attachments). I send 7 reports to 27 different recipients. I can do this since the unique identifer for each recipient is coded at the first of each file. ____As is the case with many things in programming and client service, we have to get outside the box.__Rick Johnson

[kfleming]

In RTF headers and footers are sent to explicit header/footer sections.__If you are viewing the RTF in Word, make sure you have View Header/Footer enabled if you want to see these sections while viewing the document on the screen.____Kathleen__R&R Support

[Bruce_Gardner_(Guest)]

Thank you for both responses.____Kathleen: I see what you mean. When I print the report, it^s pretty good. The Header block has some appearance problems that we can likely fix. And the footer does not have the correct number of total pages. But at least the report is easily read when printed.____Rick: I am curious about your reference to "unique identifer for each recipient is coded at the first of each file". Could you explain that further?____I know I am not the first to express this view, but I feel that PDF format is the best option for reports like this.____

[rickwjohnson]

When I create the files for the individual users, in my case regions of the bank, I start the file off with a region code. For example, for region 201 the file might be "201-Monthly Staffing Analysis.pdf" I do the same thing for branches, etc as I have this data in tables and I query the tables to get the necessary codes or identifiers. Then when I do the email, I just have the program attach the files that begin with "201", etc.____Feel free to contact me at rickwjohnson@hotmail if you want further information.____I get so much from this board, I am happy to share what little I know. I also think PDF is the way to go...______Rick Johnson

[Bruce_Gardner_(Guest)]

Rick:____Our client has similar needs except that they have about 20 Regions, each of whom would receive 3 separate reports. There would be 60 distinct reports in total.____I understand the e-mailing step where you send the appropriate reports based on the initial 3 characters of the PDF file.____Do you print & name the PDF files manually or have you automated that step somehow?____Thanks you for your help so far.____

[Marcelo_Alaggio_(Guest)]

Bruce,____did you get success on exporting reports to a .rtf file?__I tried to do so, but when I open the exported file with WordPad the columns dont^t appear in the exactly position as they are in the report.__My customers have to edit the .rtf file after it is generated.__Please contact me at alaggio@delphus-inf.com.br .____Best regards,____Marcelo Alaggio.__Delphus Informatica Ltda.__Brazil.______

[rickwjohnson]

I use dBase to programatically generate the r&r reports. After getting the data ready, I run a dbase report that opens rrwrunin and puts the outfile name into rrwrunin (along with other printer commands). Then, I use the run(.t.,"rrwrun rrwrunin 9") to generate the pdf files. I have 27 regions with 5 reports each. I can do all of the reports with no intervention and then press one button to generate the emails. (I always generate the emails in offline mode so that I can spot check to verify that I got them all). Then go online and send. ____If you will send me your email, I can send you a snippet of the code. Best of luck.__Rick Johnson(rickwjohnson@hotmail.com)__