Hi Guys
Is there a limit to the size of a dataset for koolgrid. Should I use koolgrid and koolpivottable to do reporting on some larger datasets 2 - 4 million records with each record containing 10 columns or am I taking a knife to a gun fight ?

With that large dataset, I suggested you use the HugeMySQLDataSource or AdvancedMySQLDataSource for Grid and surely KoolGrid can handle that large data with paging. For PivotTable, you may need to increase the memory of PHP thread and also it depends on the power of your system. Good way is to create a simple Pivot with your data and see how it goes.

Cool :), Ill do that.
I've written a middle-ware service which fetches data via rest. It returns a JSON object which I then convert to an array for Koolgrid but I think with massive reporting I'm going to have to access the database directly. I'll give that a go next week. Thanks for the advice Pete ;)