Multipe detail data inside single master
Is it possible to create a report like this:
Firstname Lastname
Children:
Current Residence
Previous Residences:
Previous employments:
So, I have one masterdata which lists information about a person, but I would need various detail data listed inside that master. I tried with Subreport, but I have stretching and shifting issues, so subreport data overwrites masterdata that is below.
So, master would be: select * from persons
Detail 1 would be select * from children where person = ?
and so on
Is this possible to achieve?
Thanks!
Firstname Lastname
Children:
Child 1
Date of birthChild 2
Current Residence
Previous Residences:
Residence 1
Residence 2
Current EmploymentResidence 3
Previous employments:
Employment 1
Employment 2
Employment 3
Employment 4
So, I have one masterdata which lists information about a person, but I would need various detail data listed inside that master. I tried with Subreport, but I have stretching and shifting issues, so subreport data overwrites masterdata that is below.
So, master would be: select * from persons
Detail 1 would be select * from children where person = ?
and so on
Is this possible to achieve?
Thanks!
Comments
So, three detail data mixed with masterdata in output.
Think cardview layout with multiple details inside (for each record).
That doesn't work or I don't understand something.
My report layout looks like this:
GroupHead
MasterData
DetailData
MasterData
DetailData
MasterData
DetailData
Each MasterData prints several fields from current row, while DetailData prints appropriate details (for instance, MasterData might have summary of taxes and detaildata might list taxes by percentage groups).
I'll try to be more specific. Report should look like this:
MasterData
Full name: John Doe
Date of birth: 01.01.1950
Number of children: 3
Childrens:
DetailData
Jane Doe (5)
Tim Doe (8)
Sarah Doe (11)
MasterData
Current residence: New York, some address
Previous residences:
DetailData
San Francisco, some address
Las Vegas, some address
MasterData
Current employment: Company Ltd
Total income for 2010: 85.000$
Income by months:
DetailData
Januery 6.000$
February 7.500$
....
December 6.500$
MasterData
Phone number: +1 542 111 222
Blue - fields displayed in masterdata
Green - detail data
Italic - bands
Now, same thing for other records. So, this is basically card view, but with detail data mixed in.
MasterData
Full name: John Doe
Date of birth: 01.01.1950
Number of children: 3
Childrens:
DetailData
Jane Doe (5)
Tim Doe (8)
Sarah Doe (11)
DetailData with RowCount = 1
Current residence: New York, some address
Previous residences:
DetailData
San Francisco, some address
Las Vegas, some address
DetailData with RowCount = 1
Current employment: Company Ltd
Total income for 2010: 85.000$
Income by months:
DetailData
Januery 6.000$
February 7.500$
....
December 6.500$
DetailData with RowCount = 1
Phone number: +1 542 111 222
In the meantime, I solved the problem with subreports and Child elements, but I will try your solution as well when I catch the time.