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

    Question

  • 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

    Wednesday, December 21, 2005 8:49 AM

Answers

  • 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.

     

    Wednesday, December 21, 2005 8:46 PM

All replies

  • 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.

     

    Wednesday, December 21, 2005 8:46 PM
  • 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

    Wednesday, March 29, 2006 1:56 PM