Exploring the Tablix’s Matrix Template in Reporting Services

SQL MVP Jessica Moss explores the Matrix in Reporting Services 2008 to create a dynamically expanding report with multiple column and row groups.

Jessica M. Moss, a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and authored technical content for multiple magazines, websites, and the book "Microsoft SQL Server 2008 Integratio...

Jessica Moss on 7/30/2009

For related videos, please search for "reporting services" in the search box on Jumpstart TV.

Philip Hickey on 8/5/2009

Excellent presenter, very well paced demo

Robert Weston on 8/11/2009

Methodical.

CK Park on 8/21/2009

Great

blaze on 9/7/2009

it would be nice to always put a link where we can copy/past the DataSet sql (to self reproduce the what is shown)

rupesh sharma on 9/11/2009

good

luther smith on 9/11/2009

Very helpful.

Gary Anderson on 9/11/2009

Would like to see how to change the subtotal fields from totals to averages.

Philip Hickey on 9/11/2009

Good clear example of Tablix and the presenter is a very clear speaker...nice pace

Dustin Ryan on 9/11/2009

Nice work, Jessica!

Diana Dee on 9/11/2009

Will there be a subsequent video on using drilldown?

ouchene on 9/12/2009

this is helpfull thanks a lot

Dean Gross on 9/13/2009

Nice, but it would have been even better to show some of the new advanced customization features of the tablix. hopefully this could be covered in a future episode.

Krishnarjun Halder on 9/13/2009

Good one.

Garth on 9/14/2009

Simple and easy to understand. Thanks!

Tonci on 10/23/2009

Awesomely explained! Thank you.

Sarfaraz Ahmed on 11/4/2009

Can we add adjacent groups in SQL 2005.

Jessica Moss on 11/5/2009

Hi Sarfaraz, Unfortunately, there is no adjacent groups in 2005. That feature came with the new 2008 tablix. Jessica

Steve Culshaw on 11/6/2009

Cool tip

ttony on 11/14/2009

Another very easy to follow video. Well done!

Pradeep on 1/30/2010

Nice Video

Anil Inampudi on 2/2/2010

Good one

ATK on 2/12/2010

very useful!!!

Charlie Bruno on 2/23/2010

Interesting, but the query for the dataset was not shown, which made it difficult to follow.

Michael on 3/11/2010

A picture is truly worth more than a thousand words! Nicely done!

Don Nesbitt on 4/7/2010

Very good I'll watch this several times to get the ideas down pat.

Salman on 4/25/2010

its alright. informative. shows multiple ways to create columns. i believe adding column grouping as was done is an exclusive feature to the tablix. such was not mentioned. felt kinda short but everything was there. so no complaint really.

Salman on 4/25/2010

sorry did not mean to be negative. video was good.Period.

raki on 5/4/2010

crap

Raymond on 4/11/2011

Too Short

James Moore on 7/7/2011

Great information. Good job!

Tom Hamilton on 7/18/2011

Good basic matrix intro, not sure the final grouping is right with respect to Sales by Country/region & Year

Steven Robinson on 12/14/2011

Very good video Clearly Presented

Steven Robinson on 1/30/2012

Excellent video

Matteo on 1/30/2012

great clear immediate

Dan on 1/30/2012

Great demo!

Frank on 2/2/2012

very good for a very short presentation

jithesh on 2/3/2012

good one

7F718A6344 on 2/16/2012

Could have spent another minute and talked more about using groups.

ravi on 5/6/2012

really helpful