is there any expression in ssrs.im using ssrs 2008 i want to convert my decimal to integer, nearest value(eg 34.5 =35)if not expression i have my code below.i have been able to convert into decimal so i convert back to integer now.i declare my variables to integer before so i now i change to double for me to find the average,which display my right result.so i want(average) to convert back to integer.here is partial of my code
Code:Public Function avrage(length As string) As Double dim Test1 As double if length >365.25 then Test1 =length/ 365.25 length =length Mod 365.25 length =year *365.25 Test1 =cstr(Math.Floor (length/ 365.25)) Test1=CInt(fix(length)) Test1= length end if end function
thanks in advance


Reply With Quote
