I have a dataset that has two datatables in it. These tables are
related via a foreign key (Let's call them Course and CourseDetails).
What I want to do is display a record from Course, then underneath
that, display the related CourseDetails records (via the
CourseDetails.C ourseID field pointing back to the Course table). I've
seen many people saying "merge the datatables." If possible, I want to
avoid that (it would require a decent amount of reworking on an
existing app. Is there anyway to make the report able to understand
the relationship between two tables? In Crystal Reports this was very
easy. In Microsoft's tools it seems difficult or maybe even
impossible? (two hours of searching have yielded no results so far).
Thank you in advance.
related via a foreign key (Let's call them Course and CourseDetails).
What I want to do is display a record from Course, then underneath
that, display the related CourseDetails records (via the
CourseDetails.C ourseID field pointing back to the Course table). I've
seen many people saying "merge the datatables." If possible, I want to
avoid that (it would require a decent amount of reworking on an
existing app. Is there anyway to make the report able to understand
the relationship between two tables? In Crystal Reports this was very
easy. In Microsoft's tools it seems difficult or maybe even
impossible? (two hours of searching have yielded no results so far).
Thank you in advance.
Comment