Over the past few months I’ve been working on the report from hell. It just about does everything you could imagine but press your shirts. One of the biggest problems we’ve had to deal with is the amount of data that needs to be processed on the fly to produce the report. After version one of the report shipped we decided to investigate different ways to access the data. That’s when we found this article on Integrating Analysis Services with Reporting Services. It covers how to use OLAP with reporting services. Our prototype worked like a champ and now we’re creating the cubes for the data to be reported against. I just wish we thought of this three months ago.
Now Playing: Blur – Song 2