We use Qlikview at work and SQL Server Reporting Services. I'm not clear on what exactly you are trying to do but Qlikview could be worth a look. There is a ful

We use Qlikview at work and SQL Server Reporting Services. I'm not clear on what exactly you are trying to do but Qlikview could be worth a look. There is a full featured demo which is only limited in that you can't share your documents with others. Two neat features of Qlikview are that it compresses everything into memory (depending on the data up to 100:1 compression) so it is quick to manipulate your data. The second feature is that it links everything and you can change your filters on the fly. The net result is that you can explore your data on the fly and get instant feedback to your filter changes.