将函数值传递给SSRS中的存储过程

Question

我有一个计算不包括周末的时间差的函数，并且我创建了一个存储过程来调用该函数。当我测试sp时，只显示了消息部分，我是新的，不确定这是否正确。我在将参数传递给SSRS时遇到了麻烦。请帮忙，非常感谢。

Alter Proc Test_1 
@DownTime datetime,
@Uptime   datetime =null  --since there are some null value in uptime column
AS  
Begin

print 'enter'

declare @duration int 
select  @duration = [dbo].[CalcWorkMinutes](@DownTime,@Uptime)
print 'abc'

;with cte_test2
as (
SELECT DownTime
,UpTime
,datediff(hh,DownTime,UpTime)  AS duration
FROM Test
)

select DownTime,UpTime,duration from cte_test2

where  DownTime = @DownTime and UpTime=@UpTime 
and duration=@duration
--print 'pass'

print 'duration'+' '+convert(varchar,@duration)
RETURN 

END 
 --execute [dbo].[test_1] @downtime ='2017-06-02 09:00:00.000', @Uptime ='2017-06-05 09:00:00.000'