Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: Design Reports RDL
Hi all,
I want to create a rdlc report using Microsoft Report Designer. Due to complexity of my data (the given below is just an example) I do not use View on Database side. So, I have to use seperate tables (data sources) for my report design. Now, as it can be seen the example below I have one report page and I want to show PERSONAL, FAMILY and JOB INFO for each person.
* There are Textboxes on PERSONAL INFO section. The data is come from table_Personal,
* There are a Table on FAMILY INFO section. The data is come from Table_Famiy,
* There are a Table on JOB INFO section. The data is come from Table_Job
and all the three tables contain Person_Id column.
Name : Christof
Surname : Robin
Age : 45
No----- Name----- Age----- Birt Place
1------ Sarah----- 12------ London
2------ Albert----- 16------ Manchester
3------ David----- 23------ NY
No------ Company----- Start Year
1------- Xyz----------- 2005
2------- T Mobile------- 1999
3------- Day Inn------- 1993
My question is;
1) I do not want to use Subreport and do not combine these tables in db side by using view (I have searchhed, but for 3 or more tables it is impossible I think).
So, is it possible to create a master-detail report like above by grouping items (table, list, etc.) and without using subreport on rdlc? If so, could you explain a little bit please?
2) I have tried to create such a kind of report like that; I use a List and inserted all the textboxes and three tables above
to this list. I assign all the three tables as Report Data Sources. I make List.DataSetName = Table_Personal and List.Grouping settings
select Group on : Person_Id and some other combination. But, unfortunately I have not managed to create such a kind of report group like above.
Could you help me please by giving some advice and if you have some sample rdlc page source please?
Kindest regards...
Posted 1-Sep-11 0:41am
Edited 3-Sep-11 0:36am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Has anybody else used rdlc grouping with Master-Detail tables like above???

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

  Print Answers RSS
0 OriginalGriff 450
1 Suvendu Shekhar Giri 130
2 Abhinav S 126
3 Jochen Arndt 100
4 Maciej Los 100
0 Sergey Alexandrovich Kryukov 9,623
1 OriginalGriff 8,870
2 Peter Leow 4,984
3 Kornfeld Eliyahu Peter 3,300
4 Maciej Los 2,456

Advertise | Privacy | Mobile
Web03 | 2.8.150327.1 | Last Updated 3 Sep 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100