How to genrate a report in Report Builder based on 2 or more lists ?
Hai Friends, I am Ali, I need to know, How can I prepare a Report based on 2 or more lists using Report Builder 3.0 1. Now i am able create a Report based on single list using with Report Builder or BIDS. 2. But I want to create a Report based on the different types of lists. Example: I am having Student Profile, Student Attendence and Student Fee Structure Lists. Here i want to show the Student Details as a Single Report based on these 3 lists. Please help me, then i can proceed for further steps. Ali.
October 30th, 2010 7:37am
Hi Ali, In your statement, you mentioned that you have three lists :Student Profile, Student Attendence and Student Fee Structure Lists, if I understand you correctly, these three lists might be three tables in your database, if you want to display all these information, you need click the Edit as Text button when you create the dataset, then type in the T-SQL to join these three tables together, make sure these three lists have some relationship. Thanks, Challen Fu
November 4th, 2010 2:03am