June 25, 2012 at 8:50 am
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
June 29, 2012 at 3:56 am
HI,
What is the use of two data sets?
Can't we implement two data set functionality in a stored procedure?
Try to create a stored procedure and use it.
🙂
June 29, 2012 at 4:03 am
Each dataset isrunning at exactly the same time which means that your global temp table isnt ready for the second proc to use it.
Try adding a wait for delay to the procs which require the gloabl temp table so that they wait for proc 1 to finish before running, or try executing them all on the same connection. Unsure on the order which they will be run in on one connection so would need investigating.
July 12, 2012 at 1:28 am
[font="Verdana"]Hi ....
Please find the below link.
http://www.codeproject.com/Articles/13725/Getting-started-with-SQL-Server-Reporting-Services
It will help you [/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply