Crystal Rep. and Views created in Oracle and more...

[chris6user]

Hello all!

Does anybody knows if I can use more then one view in one report? I know it's limited to one stpr.

If I use two views and it's goes through about 600 000 records, is it too much for Crystal?

thanks in advance

 

[reporting]

Yes, you can use more than 2 (or more) views as a data source in CR.

As to your performance question, there are too many variables... Here are some ideas to improve the performance of your reports:

1. Do your Record Selection on Indexed Fields
2. Do your Grouping on Indexed Fields
3. If you don't need to show the detail lines, turn on "Perform Grouping on Server" and hide the detail lines

HTH, John Marrett
Crystal Reports & Crystal Enterprise Trainer

http://www.e-reporting.ca

 

[chris6user]

thanks,
another question:
my report has about 100 fields to display and about 400 000 records. I can't display it as it is, every thing is too bunched up. I can't export it in exel (would be the best choice) becouse exel doesn't take more then 64 000 lines. What else can I use to view this report? Access creates a table with field names first and field values after, so half of it is useles. Any good ideas?

Thanks in advance

 

[jbullman]

You can use as many views as you want. The issue with views is usually that they each contain links, and some views cannot be properly linked with other views. There is no record limit.


Judith

Judith Ullman
Director of Training and Consulting
Innovative Information Resources
Phone/fax: 212-904-0707

http://www.innovativeinformation.com

Innovative is the Metro New York Crystal Decisions Partner, specializing
in training and consulting in Crystal Reports and report distribution
products, along with Oracle training and Data Junction training and
consulting.