Using Multi Table Dataset In Standard VS2010 Report
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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.