This event has ended!

View current events hosted by SQL Server Innovators Guild (ssig)

Enter The Matrix - Advanced reporting services with the matrix control and common table expressions

Tuesday, April 5, 2011 from 6:00 PM to 8:30 PM (ET)

Greenville, SC

Enter The Matrix - Advanced reporting services with the...

Ticket Information

Type End     Quantity
Free Ended Free  
Donation - If so inclined Ended
Share this!

Event Details

 

6:00 – 6:30 Pizza and Networking Sponsored by TEKsystems.

6:30 – 6:40 Announcements

6:40 – 8:15 Nicholas Wolford: Enter The Matrix - Advanced reporting services with the matrix control and common table expressions

8:15 – 8:30 Closing remarks and give-a-ways. 


Enter The Matrix - Advanced reporting services with the matrix control and common table expressions

This presentation will introduce the powerful capabilities of the matrix control by demonstrating the creation of a  relatively complex report from procedure creation to report formatting. Some features which will be utilized for our report include:

  • Recursive common table expressions with TSQL.
  • Multi-level grouping with the matrix control.
  • Interactive drill-down capabilities with the matrix control.
  • Dynamic formatting using expressions to create “smart dates”.

Note: I will be using SQLServer 2005 but all concepts are forward compatible and will work in SQLServer 2008.

Nicholas Wolford is a  Product Maintenance Developer with an emphasis on reporting with SSRS for Netalytics is Greer, SC.