Tuesday, February 21, 2012

Retrieve data from second dataset

The stored procedure returns 2 datasets. Is there any way to use the second dataset in SSRS2005?

I believe only the first dataset gets retrieved. You would have to create a wrapper stored procedure that would toggle between datasets based on a parameter, and then create 2 separate calls in Reporting Services.

cheers,

Andrew

No comments:

Post a Comment