Karen I will e-mail privately within 24 hours. Right now In Swedish time-zon I am preparing an evening meal. I come back soon
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 10 mars 2010 18:27 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: Reports to Excel Here's how I've used ODBC from Excel before. I will create a permanent temp table in RBase, load my data into the temp table. I will create a blank Excel template with my report headers, etc. The client knows how to use the "get external data" to load the data into the spreadsheet. It's all very simple and easy to use, and I've taught a few of my clients to use it, so I do know how it works. But for the life of me I cannot see how that simple application can work for what I want to do, unless there's more to the ODBC link than what I know... I need to end up with 100 different spreadsheets, each spreadsheet will have different data on it. In each spreadsheet, there will be break headers, followed by data, followed by break footers with totals, followed by a report total. I know I can use the ODBC link to get the raw data into the spreadsheet (altho I'm not sure if I'd have to do it 100 times...), but how then do you get all the other stuff I need, the breaks and totals and such? If you want to, email me privately so we don't gum up the list and tell me how the ODBC link would get me to that level of detail. Karen Repeating again I still think ODBC from Excel is you best option. What can I say to convince you? At least explore it! Gunnar Ekblad
