Solved

Using Multi Table Dataset In Standard VS2010 Report

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 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

15 Experts available now in Live!

Get 1:1 Help Now