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 |
|
Namshub
Starting Member
2 Posts |
 Posted - 2005-03-14 : 04:43:19
|
| I've managed to build a stored procedure which contains a temp table and returns a number of rows, depending upon a dynamic string of values.Running the Stored Proc in Query Analyser returns the required results (eg 2 rows)Running the Stored Proc in Report Services Preview Tool will only show the 1st row.I converted the SP as test to create and drop a real table on the fly (not really wanting to do this as it breaks security for this account), running this through Reporting Services displays and navigates the correct no of rows. (eg 2 rows as stated above)Can anyone explain why i'm only returning a non navigatable dataset???? for the temp table version???? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-14 : 15:24:21
|
| Perhaps the preview isn't going to the database to get the results but rather using the cached data. To see if this is happening, delete the ReportName.rdl.data file that can be found in the same folder as your rdl. RS caches the data into this data file so that you don't have to go to the database all of the time in preview mode.Tara |
 |
|
|
|
|
|
Reporting Services and Temp Table Results