Using Multi Table Dataset In Standard VS2010 Report
Posted on 2010-08-27
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.
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!