Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't waste time grieving over past mistakes. Learn from them and move on
 
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!!!!

08
December

What is the FIX function in SQL Services Reporting Services?

While messing around in SSRS, I came across the FIX function, which made me giggle a little as I was imagining a Fixer within Reporting Services sorting out all those little gremlins you get when running a report, I blame the child in me, but I digress.

So you maybe asking, like I did, what is the FIX function and what does it do?

In SSRS the FIX function returns the integer of a Numeric data field.

=FIX(Fields!Last_Year_s_Sales.Value)

It will just return all the numbers to the left of the decimal point, ignoring rounding or any data transformations.



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:

75 + 7 =