User`s guide

Linking tables in reports.......................................................................................................635
24.3.9
Multi-value columns.............................................................................................................636
24.3.10
Data Types..........................................................................................................................636
24.3.11
Integrating with PeopleSoft..................................................................................................638
24.4
Overview..............................................................................................................................638
24.4.1
To access data in SAP Crystal Reports................................................................................638
24.4.2
Integrating with JD Edwards.................................................................................................640
24.5
Overview..............................................................................................................................640
24.5.1
To access data in SAP Crystal Reports................................................................................640
24.5.2
Accessing Data Sources.....................................................................................................643Appendix A
Introduction..........................................................................................................................643
A.1
Six types of data..................................................................................................................643
A.1.1
Direct access database files................................................................................................644
A.2
Advantages..........................................................................................................................644
A.2.1
Disadvantages.....................................................................................................................644
A.2.2
Three layers.........................................................................................................................645
A.2.3
Common database formats..................................................................................................646
A.2.4
ODBC data sources.............................................................................................................655
A.3
Advantages..........................................................................................................................656
A.3.1
Disadvantages.....................................................................................................................656
A.3.2
Five layers............................................................................................................................657
A.3.3
Installing database clients.....................................................................................................659
A.3.4
To ensure correct ODBC DSN configuration.......................................................................659
A.3.5
Common ODBC database formats......................................................................................660
A.3.6
JDBC data sources .............................................................................................................663
A.4
JNDI....................................................................................................................................664
A.4.1
Five layers............................................................................................................................664
A.4.2
Supported JDBC database formats.....................................................................................665
A.4.3
Configuring the Crystal Reports JDBC driver.......................................................................666
A.4.4
Business Objects universes.................................................................................................666
A.5
Business Views...................................................................................................................667
A.6
Crystal SQL Designer files...................................................................................................668
A.7
Crystal Dictionary files.........................................................................................................669
A.8
Report Processing Model....................................................................................................671Appendix B
Overview..............................................................................................................................671
B.1
What is a "pass"?.................................................................................................................671
B.1.1
Pre-pass 1...........................................................................................................................671
B.1.2
Pass 1..................................................................................................................................671
B.1.3
2012-03-1418
Contents