SSRS: Calculation – Field Formatting

Denoting data trends by applying logic-controlled formatting, for example, employees with the most amount of accumulated Sick Leave.

To illustrate how to apply specifying formatting based on values, I’ll begin with a dataset that returns employee data.

2-calculation-field-formatting

By viewing the resultset, it’s difficult to discern any distinguishable trends in the data.

To denote those employees with over 40 hours of sick leave, I’ll assign a test for the field’s Font color property that will use a red color is Sick Leave is over 40 or it will remain black.

1-calculation-field-formatting

3-calculation-field-formatting

For the Font Weight property, I’ll assign a similar function that will make the same text bold or leave it normal.

4-calculation-field-formatting

By executing the report, I can now more easily tell which employees have over 40 hours of sick leave because their hours are red and bold.

5-calculation-field-formatting

Download 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