[AccessD] Export To Excel - Formulas Possible?

Hi Ken:

Does your approach adapt to data that might have 5 groups one month, then 10
the next? I want to make sure that once we build this thing, we're not
forever going back to Excel to modify headers, add groups, etc. 

Thanks!

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert
Sent: Friday, November 18, 2005 11:36 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Export To Excel - Formulas Possible?


Larry, 

I wrote a simple banded report writer for Excel. It will definitely handle
the row based calculations -- just put the formulas in Excel in the proper
place. It doesn't support column-based (Sum, etc.
calculations), but that is possible.

Basically, you define the report in an Excel template. You define the bands
by using named ranges. You can have Report Headers/Footers, Page
Headers/Footers, multiple Group Headers/Footers, and Records. You can even
define Optional Record groups, sort of a Can Grow/Shrink substitute where if
any field in an Optional Record group has a value, the group is shown,
otherwise if no fields have a value, it is hidden.

The groups define labels and fields by using the Locked flag under
Protection in Format Cells. If Locked is checked, the cell is treated as a
label or white space. If unchecked, the cell's contents is treated as a
field name, and substituted with the field's value when the report is
generated.

Page numbering is supported, but that's about the only report-level function
currently supported.

Its slower than other methods, perhaps, but the results can be as pretty as
you like.

-Ken
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com