Today in my 24Hrs of PASS session I highlighted the
issue of using temp tables with reporting services.
My solution is to use a design time variable, and the feature that all paths
are executed when FMTONLY is set ON
The code I used is along these lines ....
...