In my stored proc.
I have two decalred parameters as follow:
@AsOfDate varchar (20),
@Entity varchar(8000)= null
at the end of my select statement I have the following code:
WHERE (CPL.Effective_Date = convert (datetime,@AsOfDate) AND (CPD.Src_Intfc_Inst = dbo.udf_wb_GetSourceInstance('STARDIRECT'))
and (CE.Entity_Name = @Entity)
when i run the stored proc in SQL server management I get prompted to enter my parameters it works fine.
when I tried createing my report using (Crystal Report 11.5) the parameter prompter request my parameters but I get error.
failed to retrieve data from the database
detail ado error code ox
@asofdate which was not supplied
Native error [database vendor code:201]
I did create my parameter in crystal is that required ? Since I have it in my stored Proc.