Finding missing rows

[fmrock]

I have a report that pulls back a list of accounts.

Each row comes back with

Account Num
Admit_Date
Service Date

I need to find any missing rows that are between the Admit Date and Max Service Date.

Can anyone think of a technique i can use in crystal to report back the missing service dates?

 

[Turkbear]

Hi,
How are 'missing rows' determined and identified..If you mean that there should be a record for every date between those 2 dates, then you will need to create a calendar table ( 1 row for each date) and join it to your datatable





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kenhamady]

You could find gaps by sorting by date and subtracting the Date from the Next (Date). If the difference is greater than 1 you have a gap.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/