So, if I understand you correctly, you want to link the Excel sheet to a table in the database and only show the data from the database if there's no corresponding "record" in the Excel sheet. Is that correct?
If so, here's what you'll do.
1. Set up the data for the report using tables or a command in Crystal.
2. Add the Excel file as a data source. The sheet will appear as a Table in the Database Expert.
3. Join FROM the data TO the spreadsheet. Right-click on the join and modify it to be a Left Outer join.
4. In the Select Expert, edit the formula and include something like the following (using your table and field name from the spreadsheet):
IsNull({sheet.ContractNumber})
NOTE: In the spreadsheet, the first row should be the column name, not data.
-Dell
IP Logged
