水晶报表问题

[cooklitoto2009]

我用VS2008水晶报表连接Sybase 数据库，在数据库专家里想添加存储过程过去，添加不过去报错
报查询引擎错误：ADO 错误代码：0x源：ASE OLEDB PROVIDER 说明：ERRORS OCCURRED 本机错误：’

问题是存储过程我看过在查询分析器里能运行，各位大侠帮忙看看吧。。。

[笨熊熊]

看看代碼
你怎麽寫的。

[cooklitoto2009]

你要看什么代码

[cooklitoto2009]

create procedure Spq_Vip(
@persionid int,
@currDate varchar(20)
)
as
begin



select a.id,
convert(varchar,a.VipNo) VipNo, a.Site, rtrim(d.ParamTitle) as Item,
a.Guest, a.ReceiveUnit, a.ApointDate,

a.ApointTime, a.ApointCount, a.AccoLeader,
a.OurLeader, a.ApointScence, a.DinnerType,
a.ActivityName, a.UndertakeUnit, a.CarSite,
a.Contract, a.Concierge, a.PayType,
a.IsPhotography,a.IsBand, a.Security,
a.Note,
a.ModifyDate, (case when a.UseStatus = 200 then '录入'
when a.UseStatus = 0 then '确认'
when a.UseStatus = 100 then '取消'

else '其它' end) UseStatus,
b.EmpName ,a.SecurityLevel, isnull( a.IsProtect, 0) as IsProtect, isnull( a.IsHuanMu,0) as IsHuanMu
from TbbVip a,TgbEmployee b, TbbSysParams d
where a.OptrId *= b.EmpId

and a.ApointDate = c
onvert( datetime, @currDate )
and a.Item = d.ParamValue
and d.ParamType = 600
and a.UseStatus = 0
order by VipNo,ApointTime


end