web client grid?

I'm looking for recommendations on an ASP.NET control which will give pivot table capabilities against a straight data warehouse, not an OLAP cube.   Unfortunately, I don't think cubes are an option here. 

Any recommendations?

Not sure if it will meet all you needs but I know that dundas has some pretty awesome controls at www.dundas.com I havent actually seen them in production but have tried them on my machine.

You may want to look at radarcube by RadarSoft.    Very good ASP.NET and SL tools.  Their licensing model is good for any development shop as well they provide source if you need it.

I have been using their SL tools for a while.  They are very responsive.

http://www.radar-soft.com/products/aspnet.aspx

There are versions for SSAS and straight databases as well.

good luck,

Luis

DevExpress has a great ASP.NET control called the ASPxPivotGrid. You can connect it directly to a Data Warehouse or an OLAP cube. It also has great drill-through capability and integration with their Web Charts control.

Their Developer subscription gives you rights to use these and other great controls on unlimited websites. They have good support and plenty of training and sample code on their demos site.

http://demos.devexpress.com/ASPxPivotGridDemos/Summary/MultipleTotals.aspx

They also have a free trial as well.

-Angel