Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Freedom is instantaneous the moment we accept things as they are
Karen Maezen Miller
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!!!!


What's this BIGMUL function in SQL Reporting Services?

So I have just noticed the BIGMUL function in SQL Server Reporting Services, which really intrigues me.

To date I have never used it, but I thought I would check it.

When looking at the description, in SSRS for this function, in usual Microsoft fashion:

Produces the full product of two 32-bit numbers.

Makes things as clear as mud!

To the lay person, what this means, is that i you are multiplying 2 numerical fields, that creates a value bigger than a 32 bit number (2,147,483,647), then this function is for you.

If you use the expression:
=2147483647 * 2147483647
The report will produce an error message

However if you use the expression:
=BIGMUL(2147483647 * 2147483647)
The report will run, and show the value 4,611,686,014,132,420,609

This is really going to come in handy with some of my manufacturing and financial industry clients.

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


Name *

Email Address *

Comment *

To prove you are human what is:

55 + 64 =