Analytics in Action

Archive for January, 2012

Adding grouping and drill down functionality to a report in SQL Server Reporting Services (SSRS).

Introduction to adding Grouping and Drill Down functionality to simple Tabular Reports in SQL Server Reporting Services (SSRS). This simple two-step process allows you to compress flat reports and make  it easier to view large amounts of data. When used...

Adding Totals and Subtotals to a report in Microsoft SQL Server Reporting Services (SSRS).

Here is a simple demonstration of how to add totals and subtotals to a report within SQL Server Reporting Services (SSRS). Adding totals and subtotals is simple, but not very intuitive. So I hope this demo helps.

Introduction to Transact-SQL (T-SQL) using Microsoft SQL Server

Transact - Structure Query Language (T-SQL) is Microsoft's (& Sybase's) proprietary extension to  SQL. Its used for querying, altering and defining databases.  Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by...