Attendance Data From : 01/09/2009 To : 30/09/2009 -------------------------------------------------------------------------------- Shift date In Time Out Time Details -------------------------------------------------------------------------------- G 01.09 0933 1426 HERE IN BETWEEN THIS HE HAS NOT ATTENDED WITHOUT ANY LEAVE LETTERS.HERE I WANT THE DATE TO BE DISPLAYED CONTINUE…………… G 05.09 CL-F MISSING 06.09 HERE LIKE THAT I NEED TO GET UPTO THE TODATE (30/09/2009) G 07.09 0920 1807 Here my problem is I want the dates to be printed upto the todate which we pass in the run time parameters for a particular date there maybe no data but I need to get that date to be displayed with null columns.