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 |
|
Adianjali
Starting Member
7 Posts |
 Posted - 2011-01-06 : 07:09:42
|
| how to pass same parameter with two datasets in ssrs.two datasets are created without error.but report displays only first dataset fieldsplease help.Thanks in advancearjun.s |
|
|
MageshkumarM
Yak Posting Veteran
61 Posts |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-01-06 : 07:53:31
|
| Extract from the link mentioned below:Reporting Services only supports reading the first result set at this point. One option is to write a wrapper stored procedure that uses the original stored procedure but only returns the second result set. Another option would be to restructure the stored procedure such that the first procedure populates temp tables and then retrieve the results from the temp tables.Have a look at:http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e0cf8f54-9895-472f-846c-c08a185e5530/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-08 : 01:38:17
|
| you can also merge results using UNION or UNION ALL if number/types of returning fields are same. and you could add an extra field with harcoded values to identify the two resultsets. then use it in report to get corresponding results at required places------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-12 : 02:52:41
|
| I think none of the reporting tools support accepting tow resultset as a sourceMadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-12 : 08:24:55
|
| thats why i suggested to merge them together and then return it to report with a column to distinguish them.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
same parameter with two dataset in ssrs