Karen In my case I have more then 100 clients wanting the same report for their individual data.
What I do is to create the permanent temporay table contaning the header and footer I need in Excel already prepared in the R:Base table I then copy the db to an iniviual place where the excel reeds the data It is almost like this special option of reports I never use I cant even rember the the name maybe pagereport or something like that where you are un charge yourself of most things like page numbers and so on 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 18:06 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: Reports to Excel Gunnar: here's more details. Each factory (> 100) needs a separate spreadsheet with just their data on it. Each spreadsheet will have the requisite titles at the top and column headers. But the data will be split into multiple break headers, followed by the data, followed by break footer totals. Yes I can create a permanent temp table to hold the raw data, and I could connect to that table from Excel (although I assume I would have to connect to it 100 different times) and bring the data into a spreadsheet. But how do I get the breakheaders to print on a separate line, and how do I get the break footers? I can't have the operator break those out because that's more work than she has to do now with the .csv file approach. Karen Well Karen I dont see your issue in detail. I need only 2 sheets in my case (Balance sheet an result sheet) I keep them the samw workbook with different sheets, they are both updated at the same tin when press updateall in Excel. For hundreds sheet I would guess you need to divide into more then one workbook. Anyway if you really needs an sample on this approach, just e-mail me privately and I will send an sample I can only say it has benefits and drawbacks, like in most situations Gunnar Ekblad
