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 |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2009-06-30 : 10:20:33
|
| We've noticed a problem with BIDS in 2008 SSRS. When creating a Dataset that uses stored procedures we could not get the result set into the report. When using the query designer the result set showed up fine.The problem is that BIDS does not prefill the "fields" properties of the Dataset when retrieving the schema from SQL server(really, how could it without running the SP?). It will add the input parameters, but not the fields that are returned. It seems counter intuitive that you would have to enter the fields returned on your own. Perhaps it would be better if those were populated from the resultset in the query designer.Anyway, if someone is having this difficulty, maybe this helps.An infinite universe is the ultimate cartesian product. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-30 : 14:12:02
|
| nope. usually once you run sp in data tab and refresh it automatically takes field values in dataset |
 |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-07-06 : 09:48:31
|
| I'll try it again, but if I recall correctly, that only worked with my simple SPs which had single select statements. My more complex SP would not populate the values.Several of us looked at this, but I will check again.An infinite universe is the ultimate cartesian product. |
|
|
|
|
|
|
Dataset issues with Stored procedures --workaround