| Add data file Button |
|
You use the Add Data File Button, to add another database to your report. When you click the Add Data file button, the Choose File dialog box appears. You use this dialog box to select the database file or files you want to add to your report.
|
|
The Add SQL/ODBC button lets you add a database from a SQL or ODBC source. When you click the Add SQL/ODBC button, The Log On Server dialog box appears. Use this box to Log onto an SQL/ODBC server and select a database for use in your report.
|
SQL Join Types
Crystal Reports enables you to specify the type of join you want to use when it joins SQL tables. The join types are as follow:
|
| Equal join |
Left outer join |
Right outer join |
Greater join |
| Less join |
Greater or Equal join |
Less or Equal join |
Not Equal
join |
|
|
Stored Procedure
|
|
Crystal Reports enables you to build reports using stored procedures from those SQL databases that support them. The program assumes that the stored procedure you use for creating a report will generate a result set, and it makes that result set available as a table. If the stored procedure requires parameters, those parameters are stored with the report.
You use this command if you want to change the parameters for the stored procedure you are using in your report.
|
|
|
|
|
