HI I have 2 tables from an Oracle database that I want to use in a Crystal Report. One is a main table with most of the info and the other one is used just to retrieve the paycode info.
If the main table does not find a match in the secondary table is this record dropped completely as I wouldn't want that but would want to code something to the effect that this customer does not have a paycode. I believe the Crystal default is to drop unmatched records but I wanted to verify that.
If the main table does not find a match in the secondary table is this record dropped completely as I wouldn't want that but would want to code something to the effect that this customer does not have a paycode. I believe the Crystal default is to drop unmatched records but I wanted to verify that.