>I have been using this routine that was posted here for VFP FastXTab for a long time on the VFP development. I was wondering if anyone has written a cross-tab class in C# or VB.Net?
>
>Thanks
>
>Kirk

What do you use for your database? In SQL Server 2005 and up you need to look into new PIVOT clause.

See http://sqlserver-qa.net/blogs/t-sql/archive/2007/08/16/1338.aspx

See also http://www.aspfree.com/c/a/ASP.NET/Extending-an-ASPNET-Datagrid-to-Support-Simple-Cross-Tab-Reporting-The-Structure/