can someone please tell me how to put datediff results in a variable in a stored procedure and call it from an ssrs textbox .
1. in stored procedure:
select,column1,column2 , salesprice,
@datediffresult = datediff(dd,date1,date2) from table
2. in SSRS Expression
=sum(iif(@datediffresult >=1 and <=7), (Fields!salesprice.value)
I know that the above is not the right way to do it but does anyone have any idea how? thanks