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 |
|
Sojarat
Starting Member
11 Posts |
 Posted - 2008-03-04 : 18:02:13
|
| Hi,Running into a quirk with creating a new dataset in RS 2005.The dataset is based on a SQL proc, which I can identify and execute in the Data tab page and see the correct results when matched against the same params in SQL Studio.However, the DataSets window only lists a single field call "ID" under my available fields listing, even though I can see all the correct fields in the pane right next to.The structure of the sProc is similar to many that I have create reports on previously.Any suggestions would be helpful....Sincerely,Baffled by SSRS |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-05 : 05:36:09
|
| First check that you have one and only one SELECT query batch in your SProc that provides the final result. Once you're sure that you only have a single final select that brings the data you want and still you're having the problem. Just create a new dataset and try executing SP. that might solve it. I once had this problem and it got solved when i recreated a new dataset for same SP. |
 |
|
|
|
|
|
Dataset not properly displaying result set