?
Solved

Using Multi Table Dataset In Standard VS2010 Report

Posted on 2010-08-27
5
Medium Priority
?
1,013 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

Python: Series & Data Frames With Pandas

Learn the basics of Python’s pandas library of series & data frames and how we can use these tools for data manipulation.

Question has a verified solution.

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

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

801 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