If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic Reporting System
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 |
#2
|
|||
|
|||
Dynamic Reporting System
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] |
Thread Tools | |
Display Modes | |
|
|