[AccessD] Rube Goldberg Would Have Been Proud

Gary, Darryl, Stuart,

Thanks for the help and insights.

I do have one question, however.

Why make things simple when you can make them complex and wonderful?
:-)

Brad

~~~~~~~~~~~~~~~~~~~~~~~~ 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Sunday, August 05, 2012 4:38 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Rube Goldberg Would Have Been Proud

AKA Data Warehousing.

One way I've done this it is to build a "master" database with empty
denormalised tables.  
The nightly (or on demand) process creates a copy of the empty database
and populates the 
tables from the operational data - the reports then run on this
de-normalised data.

Tthat avoids the bloat of populatng/re-populating "temp or not so temp"
tables.


-- 
Stuart

On 5 Aug 2012 at 12:30, Gary Kjos wrote:

> I guess I would have the query that the report is based on save it's
output
> into a temp or maybe not so temp table - perhaps have rows with
creation
> dates and then you could go back to previous days report data. Then
the
> actual report would be modified to read this "reporting table" rather
than
> the source data directly.
> 
> GK
> 
> On Sun, Aug 5, 2012 at 11:56 AM, Brad Marks
<BradM at blackforestltd.com>wrote:
> 
> > All,
> >
> > I am working on a high-level one-page "Executive" report that pulls
data
> > from many data sources in order to provide Key Metrics in one
central
> > place.  This report will be automatically generated every night.
Because
> > of the amount of underlying data and because of the number of data
sources,
> > it takes about 4-5 minutes to generate the report.  So far, things
have
> > worked nicely.  The generated report is going to be automatically
e-mailed
> > to key people and it is going to be stored as a PDF file.
> >
> > During the day, the previously generated PDF file (from the night
before)
> > will be visible from an Access application.  This also is working
nicely.
> > (1 second response time)
> >
> > So far, so good.
> >
> > Now, there is a need to provide "Links" from the one-page report to
detail
> > reports.  This is not a problem if the report is generated and
viewed via
> > "Report View" (Access 2007).  This works nicely, except that it
takes 4-5
> > minutes to generate the report.
> >
> > I am trying to come up with a faster solution.
> >
> > Here is what I am considering.  After the report is automatically
> > generated at night (in PDF format), I will automatically convert the
PDF
> > file into a JPG file.
> >
> > Then I will use this JPG file as a "Linked Image" in another Access
> > Report.  Next I will add Buttons on top of the Image for the Links
to the
> > underlying details.
> >
> > Has anyone else tried something along these lines?
> >
> > Is there a better or simpler way to do this?
> >
> > Thanks,
> > Brad
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> 
> 
> -- 
> Gary Kjos
> garykjos at gmail.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.