Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2010

Flipping a Table Sideways

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

0 comments, 590 reads

Posted in BrianKMcDonald on 28 May 2010

Using PATINDEX to Split Column Data

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

0 comments, 293 reads

Posted in BrianKMcDonald on 20 May 2010

Using the Report Items Collection in Reporting Services

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

0 comments, 224 reads

Posted in BrianKMcDonald on 12 May 2010

SSRS - Time Saver using Templates

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

0 comments, 247 reads

Posted in BrianKMcDonald on 12 May 2010

Running Totals Using Reporting Services

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

0 comments, 890 reads

Posted in BrianKMcDonald on 12 May 2010

SQL Saturday 38 Presentation

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

0 comments, 174 reads

Posted in BrianKMcDonald on 12 May 2010

Time Matters: Part 1

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

0 comments, 218 reads

Posted in BrianKMcDonald on 10 May 2010