Now it is actually running without returning any errors. However it is returning and highlighting dates from 2002 and so on. I only want dates between {?StartDate}and{?EndDate} and where {worklog.date} isnull. Your thoughts?
I seem to be having difficulty with this part {?daterange}. I need it to be in between {?StartDate} and {?EndDate}. I took the parameters off, but I still need to be able to enter different dates at all times. Your thoughts?
I think I need an isnull formula, but maybe not. The point of this report is to pinpoint Consultants that have not turned in their timesheets for the week. I created a simple report with Crystal 8.5,ODBC,SQL 2000. I linked the consultant table with the worklog table with a left outer join...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.