[AccessD] Rube Goldberg Would Have Been Proud

Gary Kjos garykjos at gmail.com
Sun Aug 5 12:30:48 CDT 2012


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


More information about the AccessD mailing list