April 12, 2007 at 1:16 pm
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))
April 13, 2007 at 8:55 am
It's a guess but i'd say the datatype of your tblReferralTransferStatus.DateModified is a varchar not a datetime, so RS has provided you with the appropriate data entry control for varchar (ie a textbox). You *could* try (ie not saying this will work) manually setting the parameter type to date which in RS should then provide the user with the calendar control. Your query should then work as you've stated it (although i'd personally be doing a convert rather than cast where i explicitly controlled the output data format as you could possibly run in to cultural differences).
Steve.
April 15, 2007 at 11:24 pm
Please check the data type of these columns, it must be other than the date time. if no then let me know , so that we can find out some other solution.
April 16, 2007 at 6:35 am
Yes i changed the datatype it worked.Thanks for the help!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply