I have an issue which i dont think is unique and hoping someone has come across a solution previously;

My machine is extremely powerfull and can run huge excel/powerpivot files at ease (12 processers and 32gb ram), however most of the people viewing my data are running little spec laptops and struggle to even open the data files let alone do anything with them.

Has anyone come across a peice of software or solution to pivot some data, without actually opening the data as such, so you run the pivot set your criteria it goes off gets the data and then just shows the results with no way of diving down except re running the report. I am kinding of remembering some SQL stuff here, but not familiar with it.

I have found something that seems to do the job "http://www.clickview.co.uk/" however it is quite costly, any ideas would be much appreciated.