I just finished a similar project. What we ended up doing was creating a
Crystal Query from the Oracle view, using the query to summarize as much as
possible. The reports (5 of them) were then created off the query. The query
ran each night after midnight and the reports ran during the day. Using the
query reduced the traffic on the Oracle server.
Brian
Quote:
> Hi
> I have my database in oracle & i need to make reports in Crytal
> reports. In my one reports its has rows from 22 tables . What should I
> do. should I create queries in access & then append to table or should
> I need to create a view but it would be huge view even the data that
> need to be concatenated to one column is from different types of field
> & giving error in creating view. what is the best method? any Idea
> Thanks
> --
> kushan
> Sent via Deja.com
> http://www.deja.com/
reports