Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Beginer2012
Starting Member
45 Posts |
 Posted - 2012-06-25 : 10:51:37
|
| Hello,I have seven embedded datasets defined in my report. Each dataset calls a different stored procedure stored on the same SQL server. All dataset uses one shared data source.My first dataset calls a procedure that reads data from a text file and store it in a GLOBAL temporary table, and then it selects data from that temporary table.However, the next dataset uses that global table to select data... it is not recognising the global temporary table and I have to read the data again from the text file into a temporary table.For me, the connection is getting dropped when the report building the datasets...Does SSRS reset the connection when building datasets for the same report from the same shared data source?What is the solution for this issue?Temporary tables are a must, since the text file is getting updated by the minutes, and I have many users using these reports at the same time...So, I'm creating unique global temporary table for each user...Thank you |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-25 : 12:07:11
|
| Why not have a permanent table and include the user id as a column. Can delete for the user id on entry.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SSRS Datasets and Datasources