Solved

Using Multi Table Dataset In Standard VS2010 Report

Posted on 2010-08-27
5
1,007 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
  • 3
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Which reporting tool are you using?

mlmcc
0
 

Author Comment

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

0
 

Accepted Solution

by:
bluem1 earned 0 total points
Comment Utility
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 100

Expert Comment

by:mlmcc
Comment Utility
I don't know anything about that product.  

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Setting location of a form 4 21
Check if number is currency 15 27
Change data in datatable 8 13
String manipulation 15 48
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now