[RBG7-L] - RE: Exporting Reports to Excel Files - 7.5

[Gunnar Ekblad]

I have send a sample privately to John on R:BASE ODBC reporting to EXCEL. Should any one else require it, e-mail me privately. The sample is set up with 7.1 ODBC Driver   Gunnar Ekblad   -----Ursprungligt meddelande----- Från: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] För John Docherty Skickat: den 11 november 2005 22:14 Till: RBG7-L Mailing List Ämne: [RBG7-L] - RE: Exporting Reports to Excel Files - 7.5   Gary / Javier,   Thanks for the advice. I have been simplifying the report this morning – I changed the paper size to A3 landscape to make room available, put more space between the columns etc. and it all seems to work properly.   Gunnar – no hurry bit I would be interested to see what you have done.   Thanks & Regards, John Docherty From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Saturday, November 12, 2005 8:48 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Exporting Reports to Excel Files - 7.5   I agree with Javier on the simple approach.   The simplier the better.   However, when I developed a complicated report, it could not print to the spreadsheet and show all the information.  The font size was 6, the report had 18 columns and I printed landscape 8-1/2 by 11.  The data would not completely appear on the printout although it looked great as a PDF report.    Solutions was to create another report with the same fields, changed the font to Arial 10 and expanded the length to 15.5".  I then tested the placement of each field on the report to ensure all the results printed.  Now when the print method of XLS is chosen (coded), the program selects the correct report to use.   All the data comes through correctly with all the calculated results.  There are some lines that I removed but for the most part, I can use the report as printed.   Gary ----- Original Message ----- From: Javier Valencia To: RBG7-L Mailing List Sent: Thursday, November 10, 2005 9:47 PM Subject: [RBG7-L] - RE: Exporting Reports to Excel Files - 7.5   John: Just a couple of suggestions. Keep the report simple, no fancy formats. Also, make sure that the data is not arranged tight, leave plenty of space between fields. I have found that it is difficult to retain the format, in one instance, I ended up creating a temporary table, populated it with code and then exported it to an Excel spreadsheet; it worked pretty well for what I needed. Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of John Docherty Sent: Thursday, November 10, 2005 9:21 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Exporting Reports to Excel Files - 7.5   I am having some difficulty getting reports exported to XLS files to accurately reflect the information in the report. I gathered from an earlier post that this was an area that was still being ‘enhanced’.  If anyone has any tips on how to set up a report to increase the accuracy of the final file XLS they would be much appreciated.   Thanks,   Regards,   John Docherty     -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.362 / Virus Database: 267.12.8/166 - Release Date: 10/11/2005 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.362 / Virus Database: 267.13.0/167 - Release Date: 11/11/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.362 / Virus Database: 267.13.0/167 - Release Date: 11/11/2005