All Dates Required

[tresesco]

Hi All,

I have a basic and common issue. I need to show the attendance of the employees date-wise. The database captures the records using bio-metric system. So there are no data of the employees for the absent days. I need to show those days even in the reporting as absent - days. I have created a common calendar which has all date dates, but now i am not finding any easy way out for the reporting. Please help with your valuable inputs.

Thanks & regards,

tresesco

[tresesco]

Hi All,

Please have a look at this issue.

[renjithpl]

Can you send a sample structure of your table. ?

[tresesco]

Hi Ranjit, Here is some idea of data and what i want..

Emp ID	Attendance			Output for Emp ID =1
1	1/2/2010
2	1/2/2010			Emp ID	Date	Att_Status
3	1/2/2010			1	1/2/2010	Pr
4	1/2/2010			1	2/2/2010	Ab
2	2/2/2010			1	3/2/2010	Ab
3	2/2/2010			1	4/2/2010	Ab
4	2/2/2010			1	5/2/2010	Pr
1	5/2/2010
2	5/2/2010

[#5]

Cant your simply select show null values for the dimension?

or if null create a value?

[tresesco]

Hi Chris,

Thanks for your interest. But the matter is - there is no data for some dates in between, so we can't simply say that if NULL then do this(because we need to tell that NULL against which Field...and there is no field value for those dates). For that we have to make a common calendar which contains all tha dates(which i have done). But again, after that, those dates are required to be associated with all Employee IDs. Then only we can associate the exsisting DATEs with the common calendar Dates. What i found is a bit lenghty and probably not optimised way. I am expecting a better solution in your expert inputs.

Thanks & Regards,

tresesco