I honestly could have sworn up and down the church aisle that I’d posted something in these a few months ago. Obviously, wires got crossed either in the real world or the nether of my mind. But long story short, here are a couple great resources to use when building reports using Reporting Services.
The first is basically a best practices document that is wholly worth the read. And the second lists some of the more common limitations that are out there as suggestions to future reporting services versions.
Enjoy!
Strate SQL 