A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Dynamic Reporting System



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2010, 01:07 PM posted to microsoft.public.access.reports
Sharkbyte
external usenet poster
 
Posts: 110
Default 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  
Old May 17th, 2010, 04:32 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.