Sharkbyte said:
Has anyone experimented with, or completed, any kind of dynamic report
building system, within Access? This would be for use from an MDE, not the
Reports tab.
I would be interested in looking at how you were able to accomplish this.
Depends on what you think "dynamic" means.
If you want users to create their own reports with whatever
data and layout they might dream up, then explore providing
them with a separate playground mdb file that has links to
the tables mdb file and maybe a few queries to collect data
from related tables.
If you want them to just be able to select the fields from a
big table/query and sort/group in various ways, then create
a report and layout that contains a sufficient number of
group headers/footers and a bunch of unbound invisible text
boxes and manipulate them when the report is opened.
If all you need is to filter the data in various ways for a
predesigned report, then use a form with controils for user
to specify the criteria and some VBA code to construct the
OpenReport method's WhereCondition argument.
