Solved

Using Multi Table Dataset In Standard VS2010 Report

Posted on 2010-08-27
5
1,010 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
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 100

Expert Comment

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

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33573104
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
vb.net winforms sizing/resolution? 4 42
abstract class C# 1 31
DataGridView / get bound table name? 8 24
Groupbox Control ? 2 17
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…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

840 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