Cool thanks and for others who don't know what Aspose.AdHoc
Aspose.AdHoc
-------------------------------------------------------------------------------
The Ad Hoc Query Builder component is an ASP.Net component that can be used for a wide variety of task, ranging from Ad Hoc reports to quick and easy search screens. Developers can simply drag and drop the ad hoc component on to their web form, assign a DataTable object as the data source and let the component do the rest. The Ad Hoc component uses a DataTable object as its data source allowing developers to use virtually any database back end. The Ad Hoc component offers a variety of output, including: SQL statement, Select statement, Where statement, Order By statement, Filtered Data Objects and many more.
Allow your users to build their own ad hoc reports!
Check out a Live Demo of the power and flexibility offered by the Ad Hoc Query Builder. Also, download a free evaluation copy to see if the product will fulfill your needs. The Ad Hoc Query Builder will work totally nag free in the development environment.
The Ad Hoc Query Builder will continue to grow and evolve. We welcome any ideas and suggestions to help make this product what you want and need!