RDLC question

Question

0.00/5 (No votes)

See more:

I have a question about the RDLC within Visual Studio. I have a list where I show data. Now within that list I want to make another list that uses a variable from the first list (a foreign key) to get data in the second list (primary key). How can I link these two so it will work?

EDIT:

I have a RDLC file. In this file I want to show data. I have a list (List A) which shows data from datasource, which gets data from Column 1. Within List A I want to have another list (List B) which shows data from a datasource that gets data from Column 2. I have added a Datasource to the List, that works fine. I put a textbox within List B. That works. I want to get data so I use an expression. But I cant get data from the second datasource, only the first. Hope this is better.

Posted 19-Jan-11 21:21pm

iamjustin

Updated 19-Jan-11 21:48pm

v2

Add a Solution

Comments

Hiren solanki 20-Jan-11 3:29am

It's not quite clear still please elucidate more.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Umair Feroze · Answer 1 · 2011-01-19T22:36:00

As far as I understood your question:
You need to have a list call list1 which will be having master column or master information. Within list1 you have another list call list2.
list2 will show up detail information of the master column which is in list1.

To do this I followed the following steps:
1. Added a list in report and droped the master field in it.
2. Added another list within list1 and droped the detail fields from datasource.
3. Now I needed to create a group in list1. So I right click on the list and selected the properties menu from it. From there a window poped up and I clicked on "Edit details group...". From the window I created an expression which was nothing but the master field name.
4. After that I ran the report and I got the master detail relation in two lists.

Hope this answer your question.

iamjustin · Answer 2 · 2011-01-19T23:06:00

Not exactly. I don't data from the first datasource, I have a second datasource.

List1 uses Datasource A
List2 uses Datasource B

List2 lies within List1.

When I put a textbox in List2 and want to get data from Datasource B I can only get data from Datasource A since List2 lies within List1 (I think).

Thats a clear as I can type it :P

RDLC question

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0