Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Faith is the substance of things hoped for, the evidence of things not seen
 
Hebrews 11:1
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

29
March

A Question of Rounding in SQL Server Reporting Services

Rounding in report writing is always a tricky business.

Does one need to round up or round down, that is the question?

In SQL Server Reporting Services there are two rounding functions:

  • CEILING()

    Returns the nearest integer greater than or equal to the specified value, i.e. it will round up, regardless of the values to the right of the decimal point.

    =CEILING(1998.67) Returns 1999
    =CEILING(107741.11) Returns 107742

  • FLOOR()

    Returns the nearest integer less than or equal to the specified value, i.e. it will round down, regardless of the values to the right of the decimal point.

    =FLOOR(1998.67) Returns 1998
    =FLOOR(107741.11) Returns 107741


If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *