472,992 Members | 3,429 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,992 software developers and data experts.

RDLC And Table Relationships

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
1 4471

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Hi5 | last post by:
Hi, I am working on a project in access 2000, Whilst I already have a table called client and seems to be related with other tables ,I tried making TBL client as lookup too, I ended up having...
117
by: phil-news-nospam | last post by:
Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of...
0
by: =?Utf-8?B?UmljaA==?= | last post by:
Hello, I noticed in the toolbox for the VB2005 Report control (RDLC file), the Line tool, Table, Matrix, List tools are all missing. Only the Textbox tool is available and listed for all of the...
1
by: John A. Bailo | last post by:
ASP.NET 2.0 Project Added rdlc file DataSet with DataTable to be populated dynamically at runtime I cannot set DataSetName in the dropdown -- it does not recognize my DataSet and I cannot...
1
by: beebob | last post by:
Hi all, I am sorry if I have posted this problem to irrelevant forum. I am working in C#, and I don't find any C# forum here. I hope someone here can help me to resolve my problem. Here is: I...
2
by: =?Utf-8?B?UmljaA==?= | last post by:
On my development machine where I have Visual Studio 2005 loaded, I have an app that uses the Report control. I can view data in report format with the Report control -- the data renders OK in the...
0
by: =?Utf-8?B?WmVk?= | last post by:
Good Day, I been looking for a day now and I couldn't find a good source of information. I have a one of a kind report wherein the RDLC file including all controls are programmatically generated...
18
by: =?Utf-8?B?SGVyYg==?= | last post by:
I'm using a ReportViewer in ASP.NET. From the development environment it works fine. When published and I try to open the page with the ReportViewer I get the error: An internal error occurred...
5
by: =?Utf-8?B?SGVyYg==?= | last post by:
I need a Table object in my RDLC with 6 columns on the top several rows, but 1 column on the bottom two rows: COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6 COLUMN1 COLUMN2 COLUMN3 ...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.