hi Friends,

pl. help me how to develop a data report using SQL server
stored procedure.

when i am trying to execute stored procedure from Data Environment from VB i am getting error.

the stored procedure contains Input/output parameters.
when i am using input parameters, i am not getting any problems.

pl. suggest me how handle outputparameters of stored procedure in Data reports. and how to print output parameter values.


store procedure:
create procedure daily_report
@count int output,
@sum int output,
@dept nvarchar(20)
as
select @count=count(*) from emp where dept=@dept
select @sum=count(quantity) from production where dept=@dept


and i am using Dataenvironment for connection/executing stored procedure.

without using Data Enviornment any other way to execute the store procedure and dispay/print the report.
thanks in advance.
bye