I created a reoport using wizard.In my quesry i took two date parameters.But when i run my report i get two texboxes StartDate and EndDate.How do i get calender button in front of the text boxes.Below is my query.



SELECT dbo.tblReferralTransferStatus.RefId
FROM dbo.tblReferralTransferStatus INNER JOIN
                      dbo.tblDownloadTracking ON dbo.tblReferralTransferStatus.VendorId = dbo.tblDownloadTracking.VendorId AND
                      dbo.tblReferralTransferStatus.DateModified < dbo.tblDownloadTracking.DateModified INNER JOIN
                      dbo.tblVENDOR ON dbo.tblReferralTransferStatus.VendorId = dbo.tblVENDOR.VendorId
WHERE (dbo.tblVENDOR.VendorName = @vendorname)AND (dbo.tblReferralTransferStatus.DateModified >= CAST(@StartDate AS varchar)) AND (dbo.tblReferralTransferStatus.DateModified < CAST(@EndDate AS varchar))

Make sure that in the Report Parameters that the data type of your StartDate and EndDate are set to DateTime. That should automatically make the calendar appear when the report is run.

Hi Shivani!
solution for ur problem is very easy.
Open the Parameter Property Window, Select The Parameter, and Set the Data Type of the parameter "Date Time" provided in combo box.

Hari Narayan Sharma
Software Engineer
Harbinger TechAxes Pvt. Ltd.
Jaipur
Mobile: 09214444048