User`s guide

How subreport linking works................................................................................................491
22.1.2
Inserting subreports.............................................................................................................492
22.2
Previewing subreports..........................................................................................................493
22.2.1
Saving a subreport as a primary report.................................................................................494
22.2.2
Updating subreports.............................................................................................................494
22.2.3
Linking a subreport to the data in the primary report............................................................495
22.3
To link a subreport to the data in the primary report.............................................................496
22.3.1
Linking a subreport to the main report without modifying the selection formula....................497
22.4
To link a subreport to a main report without modifying the selection formula........................497
22.4.1
Combining unrelated reports by using subreports................................................................497
22.5
To combine two unrelated reports........................................................................................498
22.5.1
To combine three or more unrelated reports........................................................................498
22.5.2
Using subreports with unlinkable data..................................................................................498
22.6
Linking to/from a formula field..............................................................................................499
22.6.1
Linking unindexed tables......................................................................................................500
22.6.2
Creating an on-demand subreport........................................................................................500
22.7
To create an on-demand subreport.......................................................................................501
22.7.1
Adding captions to on-demand subreports...........................................................................501
22.8
To add a caption...................................................................................................................501
22.8.1
Showing different views of the same data in a report...........................................................502
22.9
Understanding Databases...................................................................................................503Chapter 23
Databases overview.............................................................................................................503
23.1
Relational database basics...................................................................................................503
23.1.1
Indexed tables......................................................................................................................504
23.1.2
Using SQL and SQL databases............................................................................................507
23.2
What is SQL?.......................................................................................................................507
23.2.1
SQL DBMS.........................................................................................................................509
23.2.2
How does Crystal Reports use SQL?...................................................................................511
23.2.3
The SQL language...............................................................................................................512
23.2.4
Defining an SQL Command..................................................................................................514
23.2.5
Changing data sources.........................................................................................................517
23.3
To change the data source...................................................................................................518
23.3.1
Working with aliases............................................................................................................519
23.4
Linking tables.......................................................................................................................520
23.5
Link from and link to.............................................................................................................520
23.5.1
Link relationships.................................................................................................................520
23.5.2
Performance considerations in one-to-many links.................................................................521
23.5.3
Data file considerations........................................................................................................524
23.5.4
SQL database considerations..............................................................................................526
23.5.5
Performance considerations for all reports...........................................................................527
23.5.6
2012-03-1416
Contents