• Are you trying to create a crosstab of some type? Or are you trying to create something that looks like labels? Both are reasonably easy in SSRS.

    You can create crosstabs in T-SQL... Jeff Moden posted examples in the Articles section... here's one:

    Jeff Moden's Crosstabs Article[/url]

    If you're using SSRS, you can use the Matrix wizard... although it's not clear what the non-first rows and columns represent from your example. What do they represent? In a crosstab, they're some kind of summary function: SUM, AVG, MIN, MAX... etc.