I have two reports, on gives me a summary of hours by date without the detail of the transactions detail beneath it. Therefor I build another report that contains all the details I need.

I let an extra column generate an http link to the report with the filter values in the url.

'<a href = /ai6/ai.asp?UID=&PW=&DAI_R=1576&DAI_S_STARTDATE='+CONVERT(VARCHAR, Trans_WeekStart, 101)+'&DAI_S_J2AIQQ046EMPLOYEEIDNO='+CAST(Empl_EmployeeIdno AS VARCHAR)+' target=new >'+D_EmployeeName_D+'</a>'
Transferring the EmployeeIdno is easy and working just fine but how do I apply a filter between two dates?