cannot see the 2nd table(2 tables returned from stored procedure) in dataset in report designer

Hi,

I am using stored procedure(SP) to create the dataset in report designer. My SP is returning 2 tables/recordset and i am only able to see first table/recordset in the dataset in report designer. I have to place fields from second table onto my report. Is there anyway i could get the 2nd table in my dataset so that i could place the fields in my report.

Please help

This is by design. We'll only look at the first resultset.

You create a second sproc to return the second resultset and build a second dataset to consume it.

|||

Hi

I am also facing the same problem. Could you help how to write a stored procedure to retrieve the second table from stored procedure. So that I will create second dataset as you said.

Thanks & Regards

Kumar

cannot see the 2nd table(2 tables returned from stored procedure) in dataset in report designer

Hi,

I am using stored procedure(SP) to create the dataset in report designer. My SP is returning 2 tables/recordset and i am only able to see first table/recordset in the dataset in report designer. I have to place fields from second table onto my report. Is there anyway i could get the 2nd table in my dataset so that i could place the fields in my report.

Please help

This is by design. We'll only look at the first resultset.

You create a second sproc to return the second resultset and build a second dataset to consume it.

|||

Hi

I am also facing the same problem. Could you help how to write a stored procedure to retrieve the second table from stored procedure. So that I will create second dataset as you said.

Thanks & Regards

Kumar