Stuart McLachlan
stuart at lexacorp.com.pg
Sun Aug 5 16:37:48 CDT 2012
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 >