The performance is NOT slow. It is in the design/layout mode when laying out the report that it is slow(insert more detail lines or whatever).  I can mess around with the report changing properties like hiding a group header and all of sudden I will get the whole report in the Print Preview. However, I still get a blank page inbetween each page on print preview but not just preview. Also the preview does show everything. It is the PRINT PREVIEW or EXPORT TO PDF that only shows partial results. So in other words, PREVIEW SHOWS THE WHOLE REPORT. Print PREVIEW/EXPORT TO PDF is inconsistant, depending on what I do and there is no rhyme or reason to what I do. It may simply be close everything and come back to it later.  

Again the query itself it running just fine.

I'm running on a development box that is both the client and the server.