Crystal Reports in the Real World—SQL Commands
Experienced report developers will notice that the sample database is very simple (only a dozen tables) and that all the fields in the tables have useful names. In practice, it's very common for a database to have many more tables with very complex relationships and that the field names are not descriptive. This is where SQL Commands can help. This section explores the advantages of using SQL Commands to create reports. To take SQL Commands for a test-drive, follow these steps:
1. | Open Notepad and type the following lines of SQL exactly as they appear here:
SELECT 'Customer'.'Customer Name' AS Name, 'Customer'.'City' AS City, 'Orders'.'Order Date' AS OrderDate, 'Orders'.'Order Amount' AS Amount ... |
Get Special Edition Using® Crystal Reports® 10 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
