Obj. Type Tables VS Perm. Table in stored procs called from Crystal

[10crystal10]

Hi,

We are using Crystal 10 against an ORacle 9i Datawarehouse.
We will be writing Stored procedures to get data for the Reports.

The questions is what Data Coding Standard is better for storing the data before returning it to crystal.
1> Each Report points a permanent Table
2> We use Object Type Table

We will be developing around 500 reports which will be scheduled to run in the night

Thanks

 

[MisterMo]

Well It Depends on what data you need to get out of you SP's
and how. The process differ from report to report.

I normally use Temp Tables if I need to do further processing before sending the data to the report

otherwise I use the most time/performance efficient process i could come up with

Mo