Basically I'm looking for a crosstab control, like the gridview but with data going down instead of across.  I need to show 7 days of data, each day would be a column.  Currently im thinking of creating 7 detailsview's and sitting them side by side but I know there must be a better option.  Any ideas???

Thanks,

Eric

First of all GridView is not a Cross Tab control,  infact it is the other way round, it display data in rows. [probably you should re-phrase your question.] 

The solution, you can use GridView and write a Cross Tab query in your stored procedure so that it gives seven columns as the out put. And use that sp data to easily bind to GridView 

Sorry for the wording.  I am looking for a crosstab control that looks similar in style to the gridview control but works on columns instead of rows.  I realize its the opposite.  I was thinking of doing a cross tab query but it would be a very nasty one because each days data contains 5 child tables with n-number of records(each day would have the same number of records though).  If I have to I will, but I thought there may be an easier solution.

Nop... if you are trying to use simple ASP.NET controls like Repeater, GridView etc you can not do that. Either you have to go for SQL Reporting or Crystal Report or a third party controls to display your data in a Cross Tab report. So if you are not planning on other tools that I mentioned then you have to write a CrossTab query