The SSRS Int function is a Mathematical function that returns the integer portion of the given numeric field or the double-precision floating-point number. The syntax of the Int function to convert or return the integer portion is as shown below. =Int(-10.4)=Int(10.546) To demonstrate the Int function in Reporting Services, we use the Products table below, … Read more
The SSRS Fix function is a Mathematical function that returns the integer portion of the specified double-precision floating-point number or numeric field. The syntax of the Fix function to return the integer portion is as shown below. =Fix(-15.4)=Fix(10.56) To demonstrate the Fix function in Reporting Services, we use the Products table below, which has 14 … Read more
The SSRS Exp function is a Mathematical function that returns the exponential value raised to the given power value (numeric field). The syntax of the Exp function to return the exponential value of a numeric field is as shown below. =Exp(3) We use the Products table below to demonstrate the Exp function in SQL Reporting … Read more
The SSRS Cosh function is a Mathematical function that returns the trigonometric hyperbolic cosine value of the given angle. The syntax of the Cosh function to return the hyperbolic cosine value of the numeric field is as shown below. =Cosh(60) To demonstrate the Cosh function in Reporting Services, we use the Products table below, which … Read more
The SSRS Cos function is a Mathematical function that returns the trigonometric cosine value of the given angle. The syntax of the Cos function to return the cosine value of the numeric field is as shown below. =Cos(90) To demonstrate the Cos function in the Reporting Services, we use the Products table below, which has … Read more
The SSRS Floor function is a Mathematical function that returns the largest integer value less than or equal to the given double-precision floating-point number. The syntax of the Floor function to return the nearest integer less than or equal to the floating-point value in a numeric field is as shown below. =Floor(4.67) – returns 4=Floor(4.27) … Read more
The SSRS Ceiling function is a Mathematical function that returns the smallest integer value greater than or equal to the given double-precision floating-point number. The syntax of the Ceiling function to return the nearest integer greater than or equal to the floating-point value in a numeric field is as shown below. =Ceiling(5.67) – returns 6=Ceiling(5.27) … Read more
The SSRS BigMul function is a Mathematical function that helps to perform the multiplication of a big number by returning the full product of two 32-bit numbers. The syntax of the BigMul function to return the full product of two 32-bit numbers is as shown below. =BigMul(2147483647,-2147483647) To demonstrate the SSRS BigMul function, we use … Read more
The SSRS Atan2 function is a Mathematical function that returns the trigonometric angle whose tan or tangent is the quotient of two given numbers. The syntax of the Atan2 function to return the angle whose tan is the quotient of two numbers is as shown below. =Atan2(3, 5) To demonstrate the SSRS Atan2 function, we … Read more
The SSRS Atan function is a Mathematical function that returns the trigonometric arc tangent value, i.e., the angle of the given tan number. The syntax of the Atan arc tangent function to return the angle of the given tan numeric field is as shown below. =Atan(30) To demonstrate the Reporting Services Atan function, we use … Read more
