INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Data Source Only Showing One Table.

Data Source Only Showing One Table.

(OP)
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

RE: Data Source Only Showing One Table.

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!

RE: Data Source Only Showing One Table.

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close