Data Source Only Showing One Table.

[Auguy]

I have created a data source from an SQL stored procedure. When I run the stored proc manually is has two tables. When I look at the data source in .Net it shows the stored proc name, but when I preview the data it shows only one table. I want to use the two tables in one RDLC report. Why don't I see the two tables?

Auguy
Sylvania/Toledo Ohio

 

[jebenson]

From what I understand, a datasource can only handle stored procs with one table. To get all the tables, you need ti use a DataSet and run the stored proc, which will fill the DataSet with however many tables the stored proc produces.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[Auguy]

Thanks, I will try building the data set manually with the two tables. Maybe then I can pass the tables to the report from the stored procedure. Seems strange that the default name for the Data source using the wizard is DataSet...., but it really isn't because it only has one table.

Auguy
Sylvania/Toledo Ohio