Karen,
I read your first thread and I think you are saying you only create one CSV file then when they receive it they have to "Pretty it up". Is that correct? Then you mention they have to do this 100 times. Is this because of the information they add on their end? Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, March 09, 2010 10:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Reports to Excel Yes, but I don't think your and Jim's way of doing it won't work in my application. I need to create about 100 spreadsheets. In each spreadsheet, there will be break headers, break footers with totals... I just don't understand how you could use a SQL-script and a live connection to the database to get these into the spreadsheet.... Karen 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
