Self-Modifying Report: Enable/Disable Footers?

[PeteCresswell]

Got a report that lists securities by issuer.

Securities are owned by "Accounts". One security may be owned by
many accounts.

Accounts have "Custodians". Each account has one and only one
Custodian.

In the dialog that solicits specifications for the report, the user
wants to specify something that boils down to "By Custodian" or "Not
By Custodian".

The obvious solution is to have two reports and open one or the other
depending.

At Report_Open time how much dynamic modification of the report can/
should I do?

I'd like to keep the spec solicitation dialog in Report_Open; OTOH, I
don't want to create a rat's nest of coding to do it.

 

[Douglas J. Steele]

Depends on the nature of the modifications. (there, wasn't that useful? <g>)

In all serious, there's a lot you can do. I have reports that pop up a
dialog form to ask for details about how you want the data presented and
then changes the report's RecordSource and/or sets a filter. What's useful
is to have a field named something like "SortKey", and change what value's
in it for each query being used as a RecordSource so that your report always
sorts by SortKey. You can change the Visible property of Grouping sections
if you do or don't want them. You can even change which field is linked to a
Grouping section.

 

[Jerry Whittle]

One thing to consider is that you can't make many modifications to the design
of a report or form if more than one person is using that .mdb or .accdb file
(except in some really old versions of Access). Therefore you must have the
database split and a copy of the FE on each user's PC or there may be some
strange problems.