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

Hot Topic

Experts required to validate these statements of fact
Dynamic Login & User Creation
Unable to drag stored procedure onto component
SELECT INTO OUTFILE?
Stored Proc
Design question SQL Server 2005
Custom Assembly generates error in Aggregation Wizard
Query behaviour
Do you regularly reboot your server?
Connection Issues

SQL Server

Parameter problem
creating a server instance on SQL server 2005 enterprise
SQL 2005 specifications and performance documentation
Display Dynamic Column in the report
Doesn't like a particular namespace
JOIN problem with time involved
How to run only certain tasks
Windows XP Home Edition
Unable to modify or create new tables...
Can This Be Accomplished in My Time Dimension in my AS2005 Cube?

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




Answer this question

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

  • Raja Pratap

    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.

     

  • BrianBT

    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
Answer this question