Hi,
My crystal report has two parameters startdate and enddate coming from sql server 2000 store procedure as data sourcen.even though both the parameters declared as datetime,the data type of the parameter in CR is greyed as string hence the calendar is not coming in the prompt. I need to change the data type from string to datetime.is it possible to change that at crystal report side. I'm also not able to do so in the store proc as the same uses open query to connect to oracle . can some one help me resolve the issue.

please find the proc below..

alter proc abc

,@StartDate DATETIME
,@EndDate DATETIME
AS



declare @string nvarchar(1000)




set @string = '
select *
into xyz
from openquery (oracle,''
select distinct
h.cvc

,h.fgc
,h.hbfhf
from root r
inner join gtrtd_ght h
on r.hncid = h.hncid
inner join fgsd_hjf p
on h.hncid = p.parentid


where stat_Date >= to_date (''''' + CONVERT(varchar,@StartDate , 112) + ''''', ''''YYYYMMDD'''')
and stat_Date <= to_date (''''' + CONVERT(varchar,@EndDate , 112) + ''''', ''''YYYYMMDD'''')


/*exec sp_executesql @string*/
exec(@string) < =text/>