I am creating a report which calls a stored procedure. This stored procedure is cross tabular and returns an undetermined amount of columns back in the dataset. Is there a way to auto generated the columns in Reporting Services 2005. I want something that will work like a grid object, which dynamically's generates the columns in the dataset. thanks..

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.