Saturday, February 25, 2012

Can I use a DataSet with 2 Tables in Reporting Services

I have created a DataSet with Table[0] and Table[1] in a stored proc. When I
create a new dataset using the stroed proc, I can only see Table[0]. Is it
possible to create a report using a DataSet with 2 tables such as this?
Thanks...Greyhound,
This is not possible. You have two choices;
1) Create two datasets in your report and split your stored proc up.
2) Union the results for each table into a single table and add a filter
field to filter the results in the report.
AK Code Rat
"Greyhound" wrote:
> I have created a DataSet with Table[0] and Table[1] in a stored proc. When I
> create a new dataset using the stroed proc, I can only see Table[0]. Is it
> possible to create a report using a DataSet with 2 tables such as this?
> Thanks...

No comments:

Post a Comment