Hi there,

I'm experiencing problems when I try creating reports directly using a pass through query.

The pass through query, which runs against SQLSever 2008R2, takes an instant to return data. When I try and create a report I constantly get the hour glass coming up each time I drag a field onto the report or even just moving a field around. It seems as if there is a constant refresh(?) going on every time you try and do something with the source fields. This is so bad it's almost impossible to build the report. Further, the report takes noticeably longer to run than the code by itself.

Am I doing this the right way or is the general practise to feed the data into a table first and then report off that?



Any suggestions and insights as to how this works, I would be most grateful.

Cheers

Niven