Adding Calander Control In VS2005 reporting
I am trying to add a calendar control for both start Date and end date in my reports using Visual Studio 2005. I have copied code from a working report created by another user but this will not give me the calendar control for the user to select a date from.
I have went under toold and added the calendar control for the tool box but this did not add the calendar in the tool box. I have been up and down the net looking for a quick way of enabling this control and allowing me to add it to the two input boxes. This is the SQL code I used :
SELECT VTS.dbo.Projects.ProjectName, tblPR_Activity.Name, COUNT(DISTINCT tblPR_CoachAttendingProjectActivity.CoachId) AS totalActivityCoaches,
COUNT(tblPR_CoachAttendingProjectActivity.ProjectA ctivityId) AS totalActivityTimes
FROM tblPR_CoachAttendingProjectActivity INNER JOIN
tblPR_ProjectActivity ON tblPR_CoachAttendingProjectActivity.ProjectActivit yId = tblPR_ProjectActivity.ProjectActivityId INNER JOIN
tblPR_Activity ON tblPR_ProjectActivity.ActivityId = tblPR_Activity.ActivityId INNER JOIN
VTS.dbo.Projects ON tblPR_ProjectActivity.ProjectId = VTS.dbo.Projects.ProjectID INNER JOIN
tblPR_Coach ON tblPR_CoachAttendingProjectActivity.CoachId = tblPR_Coach.CoachId
WHERE (tblPR_ProjectActivity.StartDateTime BETWEEN @StartDate AND @EndDate)
GROUP BY VTS.dbo.Projects.ProjectName, tblPR_Activity.Name
Any help in activating this control would be a benifit.