SSRS: Custom Functions

Implementing custom logic within a field.

To illustrate how to apply specifying formatting based on values, I’ll begin where my Calculation – Field Formatting article left off.

As you can see viewing the resultset, the Salaried Flag column displays True/False values which isn’t very intuitive.

1-custom-functions

To translate these values at runtime to more helpful Yes/No values, I’ll add an expression to the Salaried field.

2-custom-functions

By executing the report, you’ll see the Salaried values are either Yes/No.

3-custom-functionsDownload Report
(right-click, Save As)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s