[AccessD] Export To Excel - Formulas Possible?

Ken Ismert KIsmert at texassystems.com
Fri Nov 18 11:36:01 CST 2005


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
 



More information about the AccessD mailing list