Encounter an error Preview Report (Method:[BaseAdd])
Posted: Fri Jan 12, 2007 1:38 am
Hi, Edward.
I have encouter a problem on Preview Report.
When Preview, It display a dialog message as below:
Method:[BaseAdd]
DataTable alreadys belongs to this Dataset.
This is my SQL Query.
SELECT M.EMPNO,M.DAILYDATE,M.DAYTYPE,M.SHIFTCODE,
M.SHIFTGROUP,M.COMPANY,M.BRANCH,M.ABSENT,
M.OVERTIME,M.LATEIN,M.EARLYOUT,M.TIMEOFF,
M.WORKNONWORKDAY,M.MINIMUMNORMAL,M.MINIMUMTIMEOFF,
M.MINIMUMLATEIN,M.MINIMUMEARLYOUT,M.MINIMUMOTHOUR1,
M.OVERRIDEGROUPING,M.OVERRIDETIME,
M.OVERRIDECALCULATION,M.EXCEPTIONCODE,E.NAME
FROM DAILYATTENDANCE M LEFT OUTER JOIN
EMPLOYEEMASTER E ON (M.EMPNO=E.EMPNO)
WHERE M.DAILYDATE BETWEEN @FROMDATE AND @TODATE
ORDER BY M.EMPNO,M.DAILYDATE
In the SQL Statement, the underline part i removed it. the error above is gone.
If i put it back to sql statement, i will display that error again.
Can you help me on it?
Thanks a lot.
Nelson Chai.
I have encouter a problem on Preview Report.
When Preview, It display a dialog message as below:
Method:[BaseAdd]
DataTable alreadys belongs to this Dataset.
This is my SQL Query.
SELECT M.EMPNO,M.DAILYDATE,M.DAYTYPE,M.SHIFTCODE,
M.SHIFTGROUP,M.COMPANY,M.BRANCH,M.ABSENT,
M.OVERTIME,M.LATEIN,M.EARLYOUT,M.TIMEOFF,
M.WORKNONWORKDAY,M.MINIMUMNORMAL,M.MINIMUMTIMEOFF,
M.MINIMUMLATEIN,M.MINIMUMEARLYOUT,M.MINIMUMOTHOUR1,
M.OVERRIDEGROUPING,M.OVERRIDETIME,
M.OVERRIDECALCULATION,M.EXCEPTIONCODE,E.NAME
FROM DAILYATTENDANCE M LEFT OUTER JOIN
EMPLOYEEMASTER E ON (M.EMPNO=E.EMPNO)
WHERE M.DAILYDATE BETWEEN @FROMDATE AND @TODATE
ORDER BY M.EMPNO,M.DAILYDATE
In the SQL Statement, the underline part i removed it. the error above is gone.
If i put it back to sql statement, i will display that error again.
Can you help me on it?
Thanks a lot.
Nelson Chai.