Karen,
I have a single EXCEL workbook that has 52 worksheets (one for each week). This workbook has multiple links to other workbooks. It can be updated with a click of the update button. I also have ones with links directly to RBASE tables that update in a similar manner. If the IT guy on the other end knows how to have macros or links, I would think a single workbook could be created with a sheet for each report pre-formated for each factory. The truth is you could do it (I did it by just reading the HELP info so I am sure you could do it). Once that is accomplished, the specific information for your detail, headers, footers could be put in the RBASE tables with a field for each factory. The Excel workbook then has as many sheets as needed that attach to the tables. Hitting the update button on the Excel sheets will automatically update all 100 "report" sheets based on the factory id. Of course this is all predicated on the Excel sheet having access to the RBASE tables. I now do this with a quote file our people use when creating products "on the fly" so to speak. Excel workbooks are only limited in size based on the available memory. Just a thought. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, March 09, 2010 4:51 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Reports to Excel Marco: I took a look at the .xls link that you gave me, but not sure how that would work in this application. I can have a table full of all the information for all 100 factories. What I want is a separate spreadsheet file for each of those 100 factories. In each file there will be one page (sheet) with all that factory's data. An example of the data could be: product line 1 Model 1 description of model1 1,000 active 15 Model 2 description of model 2 2,000 inactive 30 -------- ---- 3,000 45 product line 2 .... etc Report footer: 150,000 200 I don't see how pivot tables could get the data into that format without the user doing some work themselves... Writing code to stick the data into a .csv files great, giving me lines for the break headers, the footers. The only problem is that she has to bring up 100 files, run a macro to format, save as .xls. Karen With Pivot you can add a print page break for every category of for each page filter a report as tab automatic made by Excel.
