Issue:

We are working on crystal Reports 10 with BMC Remedy system.

We actually are facing issues on handling dates in crystal reports. The two cases are explained below.

While querying to remedy database, how do I capture values of dates on crystal side (StartDate and EndDate).

Issue 1:

The user selects FromDate as 1st Oct 2008 and End date as 15 Oct 2008. Assuming if the data is not there for 1st, 2nd 3rd Oct, the report does not display neither data nor the dates for which data is not there at boundary level. We could handle printing "NA" for the dates which come in between 4th to 15 Oct. The requirement is to print "NA" for all the dates for which data is not there.

How do I capture date

Issue 2:

Based on FromDate and Todate, I need to implement graph, the requirement is to display "NA" or a point or a continuous line

for the dates where data is not there.