Datasheet

Accessing Data Sources.....................................................................................................633Chapter 25
Introduction..........................................................................................................................633
25.1
Six types of data..................................................................................................................633
25.1.1
Direct access database files................................................................................................634
25.2
Advantages..........................................................................................................................634
25.2.1
Disadvantages.....................................................................................................................634
25.2.2
Three layers.........................................................................................................................635
25.2.3
Common database formats..................................................................................................636
25.2.4
ODBC data sources.............................................................................................................645
25.3
Advantages..........................................................................................................................646
25.3.1
Disadvantages.....................................................................................................................646
25.3.2
Five layers............................................................................................................................647
25.3.3
Installing database clients.....................................................................................................649
25.3.4
To ensure correct ODBC DSN configuration.......................................................................649
25.3.5
Common ODBC database formats......................................................................................650
25.3.6
JDBC data sources .............................................................................................................653
25.4
JNDI....................................................................................................................................654
25.4.1
Five layers............................................................................................................................654
25.4.2
Supported JDBC database formats.....................................................................................655
25.4.3
Configuring the Crystal Reports JDBC driver.......................................................................656
25.4.4
Business Objects universes.................................................................................................656
25.5
Business Views...................................................................................................................657
25.6
Crystal SQL Designer files...................................................................................................658
25.7
Crystal Dictionary files.........................................................................................................659
25.8
Report Processing Model....................................................................................................661Chapter 26
Overview..............................................................................................................................661
26.1
What is a "pass"?.................................................................................................................661
26.1.1
Pre-pass 1...........................................................................................................................661
26.1.2
Pass 1..................................................................................................................................661
26.1.3
Pre-pass 2...........................................................................................................................662
26.1.4
Pass 2..................................................................................................................................662
26.1.5
Pass 3..................................................................................................................................663
26.1.6
Crystal Reports Error Messages.........................................................................................665Appendix A
Drive:\filename.extension.....................................................................................................665
A.1
Drive:\test.rpt......................................................................................................................665
A.2
Failed to load database connector........................................................................................666
A.3
Failed to open the connection. Details: [Database Vendor Code: <vendor code number>]...666
A.4
2011-05-1618
Contents