Prev: Dynamically Add fields/controls to reports
Next: Export from Access to Excel disabled
From: Sharkbyte on 17 May 2010 08:07
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.

Thanks in advance.

Sharkbyte
From: Marshall Barton on 17 May 2010 11:32
Sharkbyte wrote:

>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.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Dynamically Add fields/controls to reports
Next: Export from Access to Excel disabled