views:

128

answers:

0

I am using SQL report Server 2008 and I have huge amount of data in one report after that I call sub report or linked report with same data just with another view or I need that data to write back to DataBase in other place. Now I wondering Can I access on dataset which using data to show current report and after that I want to use that Data. I usually worked whit #TempTable and also white ##GlobalTemTables and read data form there for two or three report on same parameters but some time report server Get Stacked with own temp tables and users cant work anymore until they Close connection and login again.

Thanks in advice