help with stratedgy for a 25 page report

[Craigmacs]

I am writing a large report based on Oracle. I will be running over 50 queries to display the charts and information.I need some suggestions on how to access the data most efficently.

Thanks

 

[synapsevampire]

Use Stored Procedures, as with any database, that's the most efficient way.

If you require 50 data sources, then I fear that equates to 50 Stored Procedures.

Here's a reference document:

http://support.crystaldecisions.com/library/kbase/articles/c2001157.asp

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com