Report from 2 databases

[Former Member]

There are 2 databases and a crystal report is required as shown

.

Main report consist of Schedule database. And the sub-report consist of Time Clock database. Sub-report links are Emp ID and Date.

Challenge is getting list of names in 'No Clock in Clock out' group since there is no record generated in the Time Clock database when a person does not clock in.

Any ideas?

[Former Member · Accepted solution]

You are going to need a third sub report.    That sub report needs to be driven by a command / stored procedure / view  that does the following.

Select the id number from the schedule data base where the id number is scheduled to work in the frame entered as the parameters  and  the id number is NOT  in  (  an imbedded select statement  that lists the id numbers where there are a the valid set   ( both in and out)  of  punches already recorded in the Clock in /out database for the same time frame )  

The exact code will depend on the database you are using,  the structure of the tables and fields available.  

You will need to pass the Start and stop times for the period to the sub report as parameters.