Datasheet

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