By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,892 Members | 1,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,892 IT Pros & Developers. It's quick & easy.

RDLC And Table Relationships

P: n/a
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.CourseID 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.
Jul 13 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a

did u tried the datagrid?
"dmeglio" <dm*****@gmail.comwrote in message
news:7c**********************************@56g2000h sm.googlegroups.com...
>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.CourseID 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.

Jul 15 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.