Click here to Skip to main content
11,934,380 members (43,019 online)
Rate this:
Please Sign up or sign in to vote.
See more: Design RDL Reporting
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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.151126.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