I have a formula working out datediff on two date fields , this is placed in the details section of the report,

My problem is when generating the report, the datediff formula works on most records but I have at least 3% of the records where the datediff calculation is just blank , no data shown.

I have confirmed that the database tables are populated with the necessary info.

Why would the formula show data only for some records when all are populated

 

need assistance with this as this seriously affects the report totals / averages etc.

I have double checked and all date fields do contain valid data for the period requested , my first thought was an incomplete field / null data.

but this is definately not the case , it just stops displaying data after the 4th page of the report.

 

one issue is the date fields in the database were set as string fields ( old legacy system) I use a cdate function to first convert the date to a valid date field the do the date diff function.

Second to this if I look at the detail section the dates show as blank fields , as mentioned after about the 4th page hence the datediff fields are blank. I am not aware of any restrictions on number of records crystal can process.

My dilema persists :(