Reports Database

[Cipriano_Loera]

I am trying to create a database that will be used
strictly to pull reports generated from another database.
Ex. sources and queries create report1 in database1 and
exported to database2. User will enter parameter to
retrieve report1 in database2.

Any help will be greatly appreciated.

Thnaks in advance, Cipriano Loera Jr

 

[Immanuel Sibero]

Hello,

I'm not entirely clear what you're asking. So you have two databases. You
generate reports in Database1 and would like to export those reports to
Database2?? When you say *export* the report to Database2, do you mean
export the information contained in the report?

A report is a snapshot of the current state of the your data. Now your data
always changes over time, so executing a report at different times gives you
different snapshots of the data. Is this what you're after? You're trying to
save the different snapshots in Database2?

If so, one way to do this is creating pdf files of your reports. The pdf
files would not physically be in an Access database. You would simply store
the location of the pdf files in a table. You can get more sophisticated in
Access with indexing the reports for easy retrieval, but I wont expand on
this since I'm not even sure I understand what you're trying to do.


HTH
Immanuel Sibero

 

[Cipriano Loera]

Hello and thanks for you help

Let me give you a bit more detail of what I want to do,

I wanting to create a database located in TX, this is
database1. Database1 will do all the querying and updating
and everything else (Main mdb). The database will export a
report on daily basis to several sites in different states
via WAN. I need a user database that will retrive these
reports and allow the user to view and print based on date
parameter of when the report was created.

Thanks Again
Cip

 

[Mark Andrews]

Either just have the central database and throw a web front-end so everyone
can
run the report they want or push out the exported files and just build an
interface that
uses the filename to know which one to retrieve so you don't need any
database at the
satellite locations.

Look at our report server product to build a central web site in which
everyone can run reports.

I would use PDF format for either method.

HTH,
Mark
RPT Software
http://www.rptsoftware.com