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!!!!

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:

26 + 37 =