Excel database as source data - problem with blank entries
I'm using Crystal Report version 11 and creating a report with data source in excel format.
As a brief, the excel database looks like below (to keep track of machines that have been sold and signed by customers);
<Machine No> <Sold Date> <Customer Signed Date>
Some machines are sold but customer hasnu2019t signed, hence the customer signed date is blank. Some machines are not yet sold so both Sold Date & Customer Signed Date are blank.
The problem I am experiencing is that, when Crystal Report reads data from Excel, if first records of the database have no date (ie. Customer Signed Dates are blank), Crystal Report doesnu2019t seem to recognise the field properly and all the remaining records have blank Customer Signed Date, even though there are some valid entries in the field.
Any help will be greatly appreciated. Thank you very much.
Brian Dong replied
I've run into this lots of times. The easiest way to deal with it is to have a sample record on the first line. The sample would have a value in each column. When you designe the report have the Record Selection Formula remove this record from the report.