Home » Developer & Programmer » Reports & Discoverer » Oracle to Crystal to Access or Excel even!
Oracle to Crystal to Access or Excel even! [message #203866] Thu, 16 November 2006 13:15 Go to next message
Debanjan_chat
Messages: 16
Registered: August 2006
Junior Member
Hi All,

We have set-up an Oracle database and want to use a Crystal engine to pull extracts from the data base. Before you ask, No, we can not use Discoverer.

So the issue is that the business wants to use Access or Excel. What is the best way of getting Crystal to pull an Extract from Oracle and then let Access or Excel pull from this Extract to build reports. Again we can not use Crystal for all users due to licensing amongst other idiosyncrasies here.

In short our constraints are we can not use Discoverer, we can not give the entire business Crystal and we need to run reports in Access or Excel.

Just to add the complexity our data base has 20 tables and 6 years of data in it. What is the Access and or Excel limit.

If this is not the right forum can you please forward this to the correct one.

Many thanks
Re: Oracle to Crystal to Access or Excel even! [message #204675 is a reply to message #203866] Tue, 21 November 2006 11:48 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Crystal Reports is owned by Business Objects now, so you can check their support forums:
http://support.businessobjects.com/forums/default.asp
Re: Oracle to Crystal to Access or Excel even! [message #204694 is a reply to message #203866] Tue, 21 November 2006 13:48 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Why not just use Access directly to Oracle, why use Crystal at all ?
Previous Topic: Security / admin reports?
Next Topic: procedure entry point psoasyn could not be located in orapls.dll
Goto Forum:
  


Current Time: Thu Dec 08 08:29:30 CST 2016

Total time taken to generate the page: 0.10123 seconds