Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table. No aggregations at all, just a listing of the columns as shown in the screenshot below. This happened for a colleague of mine recently. As such, a few of us… Read more

A colleague of mine received an Excel file that he needed to load into a table for future lookup values. There were some crazy columns containing multiple values inside one cell, which he needed to split up into multiple columns. Seems pretty straight forward so far right? And a pretty… Read more

Using the Report Items Collection in Reporting Services

Sometimes, you may want to do calculations or use some value that has already been used in another object. By using the report items collection, you can get the value from whatever object you want and use it in a calculation.

For… Read more

Creating a Reporting Services Template

Many companies like to have a consistent look and feel across their applications. Some even make them part of the standards. As such, one may want to create a reporting services template that allows them to start off the report with objects or properties set… Read more

Sometimes one may need to see a running number that represents a quantity for a period of time. For example, let’s say you have a month to date report that breaks out the quantity of units sold on a daily basis. And you get a request from the Sales Manager… Read more

This past weekend was SQL Saturday 38 in Jacksonville Florida. It was a great event and the turnout was incredible. My presentation was first thing in the morning and as such, I enjoyed the opportunity to pass on some of my experiences with SSRS. I had a ton of material… Read more

If you’re anything like me, you value every second of your day and you constantly try to find new ways to maximize your time. And since I find myself on the road between here and there; and there and here quite a bit lately, I really need to be as… Read more