Solved

Using Multi Table Dataset In Standard VS2010 Report

Posted on 2010-08-27
5
1,012 Views
Last Modified: 2013-11-27
Team -

Please forgive my ignorance here, I am extremely weak.  Seems like this should be extremely easy but for the life of me I can't get it to work.

Environment:
Winforms Application
Local Report
Standard Report (not crystal report)
Dataset with 4 tables all tied together with Jobid (all with primary keys, and fk)
Using Visual Studio 2010

MyDataSet holds 4 tables.  tblJobInfo is main table with Jobid as int.

All three other tables are tied together by jobid int and preview fine.  However, I can't get them added into a report.  I can get the main table data to appear in a "list" control but can't do anything with all the other tables.

What am I missing?  I tried to build a qry that would pull all the data needed into a single dataset but that didn't seem to work.  

Thank you for the education!

Dewayne
0
Comment
Question by:bluem1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 33550049
Which reporting tool are you using?

mlmcc
0
 

Author Comment

by:bluem1
ID: 33550375
The standard report viewer the comes within visual studio.  file ends in .rdlc

0
 

Accepted Solution

by:
bluem1 earned 0 total points
ID: 33567165
Going with use of sub-reports, doesn't appear to be an easy way to do what I want to do.  The reports don't seem to work like the normal winform, can't use related datatables.  it seems all data much appear in a single datatable.

I feel sure there is a better solution but I am going to adapt!
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33573100
I don't know anything about that product.  

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 33573104
0

Featured Post

More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question