Karen the way I address this problem is like this: First I create a perment temporay table with an SQL-scrpit according to my reporting needs.(with that I mean only its is a temporary table in logic but need to be permanent so it can be accessed by ODBC. Then I in Excel create an ODBC query to read my R:Base data base, once I have that I format the excel accordning to my needs and save . When I need that sheet with latest data I just press a button in excel that performs the query one time more. (There are a few minor things in the behaviour of excel)
Having said this I also believe that Excel-reporting has become better since I developed my personal workaround. Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För [email protected] Skickat: den 9 mars 2010 16:20 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Reports to Excel I don't have any 7.6 reports in production that print to an Excel file because "in the beginning" it was difficult to design a report that looked good to the screen but also could be outputted to an Excel file. And an Excel-only report had to have fixed fonts and plenty of white space. So now I have a client asking, and we would be able to design an Excel-only report. We are now creating a .csv file, writing column headers to it and unloading data as ascii. However, the user has to bring up the .csv file, change fonts, apply font attributes, resave as Excel. So since I haven't visited this topic in a while, could I design a report that would always be outputted to an Excel file, have headers in a different font, bolded, larger size, white space between headers and data, data wouldn't be dropped and could be in a proportional font, etc. I'm trying to output to an Excel file that would look good and have the users not do anything to pretty it up. They run this routine once a month on 100 different factory listings! Cannot use a PDF file because the factories add columns of data to the spreadsheets and return back to the company. Thanks! Karen
