View Single Post
  #2 (permalink)  
Old July 5th, 2006, 03:42 PM
dduvarney dduvarney is offline
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Reporting Services can't dynamically shift with a dataset that has changing columns as you have described.

However, you can use the matrix to get the same affect. First, you need to have a query that passes back a set dataset instead of a dynamic one. For Example, if you are putting months across your columns, make each month its own row (and a single column) instead. This will flatten the dataset for Reporting Services. Then use the Matrix control to get your cross tab affect. The Matrix will group by each individual month.