Interactive Reporting

Hi Guys,

I would like to ask your advice on approaching a problem before I
attempt to build anything.

The scenario is that every month we have a rather large and 'complex'
report that is generated in Excel, by one of my co-workers. To produce
this report is extremely time consuming, and the end output is limited
in its usability by the simplistic representation of the data given in
Excel. I want to change this and at the same time reduce the amount of
time required to produce the report - and I have an idea!

I was thinking that the data could be better represented with a series
of 'views' that would basically be forms with the necessary control to
analyse the data and let people play with the information. The data
that they would play with would reside in a single table, effectively
just a giant list. The views could then be pumped out to other MS
Office applications with automation if users want to play with it
further. Seems simple enough so far.

Heres the tricky bit: The only 'corporately acceptable' way to push
this report out would be to create a fresh MDE for Access 2003
Runtime. We would need to produce this MDE from another application,
or a 'builder' tool if you will. Has anyone any suggestions or
experience with producing an MDE, complete with code, forms etc from
another application - I would probably build the 'builder' tool in
Access.

In theory, if all goes well, a user could start the builder tool,
assemble the mountains of data they need for the report, do their
validation on the data etc..., and then push the resultant output data
into a 'target' mdb file, which would then be programatically turned
into an MDE. Thats the goal anyway.

Any advice appreciated. I may be a little too ambitious here
(maybe) :-)

Cheers

The Frog
.

Relevant Pages

  • Re: Am in need of adivce please help
    ... happy that her other siblings are still their any advice on residancy ... you have reported this to social services and they've just sent you ... That's really unacceptable - firstly they have a duty to make those kids are ... ring the Police and report it again. ...
    (uk.legal)
  • Re: Access query performance
    ... Thanks for the advice, subreports did the trick. ... troubleshooting advice on whether these types of problems are query or report ... "Jeff Boyce" wrote: ... > The first thing to check on slow queries is that fields used for selection ...
    (microsoft.public.access.queries)
  • Re: some kind of unremoveable spyware
    ... things goes..i asked my friend that works at qeek squad for advice and he ... Download Adware-Virtumundo Removal Tool -- ... On Win9x/ME platforms the report will not be shown in your bowser ... It would be best to scan in both Safe Mode and in Normal Mode and save a copy of the HTML ...
    (microsoft.public.security.virus)
  • Re: Stephen Lebans Report2PDF
    ... Please select a different Report to Export ... No matter what I throw (Report or existing Snapshot) at it I get this same ... the mde, and as an external library to one of my projects. ... > With reference to Stephen Lebans interesting report to PDF solution found ...
    (microsoft.public.access.reports)
  • Re: Design not working for reports
    ... Nowhere is this post does it say I'm trying to edit the report in the mde. ... its an mdb test file. ...
    (comp.databases.ms-access)