Click here to Skip to main content
Rate this: bad
good
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.
 
PERSONAL INFO
Name : Christof
Surname : Robin
Age : 45
 
FAMILY INFO
No----- Name----- Age----- Birt Place
1------ Sarah----- 12------ London
2------ Albert----- 16------ Manchester
3------ David----- 23------ NY
 
JOB INFO
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
v2

1 solution

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

Solution 1

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

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



Advertise | Privacy | Mobile
Web01 | 2.8.1411022.1 | Last Updated 3 Sep 2011
Copyright © CodeProject, 1999-2014
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