Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: parameter passing to store proc Post Reply Post New Topic
Author Message
sbhusan
Newbie
Newbie


Joined: 20 Jun 2008
Location: United States
Online Status: Offline
Posts: 1
Quote sbhusan Replybullet Topic: parameter passing to store proc
    Posted: 20 Jun 2008 at 4:23am
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/>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.