SSRS CInt Function

The SSRS CInt function is a Conversion function that will convert the given field or expression to an integer. The syntax of the CInt function for converting to integer is as shown below.

CInt(Fields!Income.Value)
CInt(10.567)

To demonstrate the CInt function in reporting services, we use the Employee table below, which has 20 records. The image shows the records in the Table report.

Source Table

SSRS CInt function Example

For this, let me add a new column to the right side of the Sales column. Next, right-click the textbox under the CInt Sales and choose Expression to open the expression window below. The CInt expression below will convert the Sales Amount column values to integers.

  1. More Functions
  2. Charts
  3. Tables
  4. Format tables
  5. SSRS
=CInt(Fields!SalesAmount.Value)
SSRS CInt Function expression to convert the column to Integer

Similarly, let me create one more new column to convert the YearlyIncome values to integers. The SSRS CInt function expression to perform this function is shown below.

=CInt(Fields!YearlyIncome.Value)

Please click the preview tab to see the report.

SSRS CInt Function to convert the column to Integer report preview