SSRS: Custom Date Formatting

Applying a custom format to date values. Since most date values returned in a dataset aren’t very intuitive due to their default precision, applying a custom format helps the user to understand them better. To illustrate how to accomplish this task, I’ll begin where the Global Collections article ended. As you can see, the report…

SSRS: Column Sorting

Applying sort ability to columns. When report data exceeded many pages, it’s important to provide a mechanism for users to easily change the sequence of the rows. I’l begin with an existing report which displays 7 pages of data concerning employee sick hours. To apply a sort to the Title column, I’ll configure Interactive Sorting…

SSRS: Conditional Font Color

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. By viewing the resultset, it’s difficult to discern any distinguishable trends in the data. To denote those employees…

SSRS: An Overview

What is SQL Server Reporting Services (SSRS) SQL Server Reporting Services (SSRS) is Microsoft’s platform for designing, developing and delivering dynamic reports. Report Types SSRS provides a variety of reports such: Tabular, Matrix reports (crosstab or pivot table) – for summarizing data and reviewing it in multiple dimensions, charts and graphs – for visually illustrating…