I have several reports where I'm pulling a bulk set of data through openquery on a sql server into a temporary table to allow for indexing prior to processing. That said, everything works splendidly for me except the built in export to excel option.
It seems that the object is being set based on the select statements in the store procedure so when you're viewing the actual report even though there are "two" objects based on the stored procedure you only see one. The export object is set to 2 and when you export the resulting output is blank. However, if you change the object to 1 all is well.
The csv and pdf exports work without issue even though they are set to object 2 by default as well.
I verified it wasn't something hokey with with I was doing. I ran basic test and had the same results.
select 'ABC123' as 'Test Entry' into #TESTING
select * from #TESTING
Any thoughts or suggestions on how I can get around this?