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.
----- Original Message -----
From: [email protected]
To: RBASE-L Mailing List
Sent: Tuesday, March 09, 2010 9:28 PM
Subject: [RBASE-L] - Re: Reports to Excel
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.
