Use functions in a report SQL Server


show more Using functions in a report in your SQL Server lets you calculate up-to-date numbers on key business data, such as number of items sold per day or other averages that can change frequently. This online video goes over setting up your server to update key data by describing this advanced SQL Reporting Services technique. show less
please wait ...

Using functions in a report

Databases are great for storing our raw data, but usually raw data isn't all we want to see. We want to see calculated values on our reports. We want to see the total sales for last week, or the average daily bug submissions for this quarter versus the same quarter last year, or perhaps the number of products we have right now with a status of Out of Stock. But this kind of information, these kinds of numbers, would not and should not be stored in the database directly because we can figure them out on the fly. We can calculate these numbers, and we will use functions to perform these calculations.

Common functions including totaling or summing numbers together, counting them, averaging them, minimum or maximum, first and last. So let's say I want to create a report in Reporting Services with the total sales for last week. Now, I could get to this total and add these numbers together in two different places. First, when I write the dataset or query or SQL I use a function that as...

Using functions in a report
Video duration: 11m 0s 3h 44m Advanced

Viewers:

Using functions in a report in your SQL Server lets you calculate up-to-date numbers on key business data, such as number of items sold per day or other averages that can change frequently. This online video goes over setting up your server to update key data by describing this advanced SQL Reporting Services technique.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...