But this presents the same problem I've said before -- how can you get break headers and break footers with totals simply by having all the raw data there? I know how to get the data from RBase into Excel via odbc, I've done that before. But nothing like trying to get 100 different reports with breaks. I don't see how that direct connection could possibly get breaks.
Karen > Maybe your use the Pivot feature in Excel 2003 / 2007 or 2010 where you > can have all data available and where you can add a page filter for the 100 > departments to show only their own data. > > The data in Excel van be automatic updated with data from a R:BASE > databas with use of ODBC. > > I have added a very simple sample based on Oterro sample database in > Excel as pivot: > > http://www.rbase.eu/files/oterro_pivot.xls > > With Excel 2007 or even Excel 2010 (PowerPivot) you can be more flexible. > >
