Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Excellence can be obtained if you care more than others think is wise, risk more than others think is safe, dream more than others think is practical, expect more than others think is possible
 
Unknown
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 *

To prove you are human what is:

1 + 32 =