revilord
Programmer
- Oct 2, 2003
- 64
Hi, I am looking for an opinion here. I will soon be accessing a SQL and Oracle Databases. I am not sure how large they are but I do know that some of the existing reports are built on queries that can take several minutes to run.
I will only have read access to the DB's, meaning I can't create any stored procedures or views on the DB's. In the past I might have used MS Access and linked tables and then created views to ease the creation of reports.
So I have a few requirements, I want to reduce the time to produce the reports and I want to make it easy on myself to modify and link the data to create the reports. I want some opinions on the best practices I could use with Crystal to create reports in this situation.
I will only have read access to the DB's, meaning I can't create any stored procedures or views on the DB's. In the past I might have used MS Access and linked tables and then created views to ease the creation of reports.
So I have a few requirements, I want to reduce the time to produce the reports and I want to make it easy on myself to modify and link the data to create the reports. I want some opinions on the best practices I could use with Crystal to create reports in this situation.