Multipe detail data inside single master

Is it possible to create a report like this:

Firstname Lastname
Children:
Child 1
Child 2
Date of birth
Current Residence
Previous Residences:
Residence 1
Residence 2
Residence 3
Current Employment
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

  • gpigpi
    edited 1:24PM
    Yes, it's possible. Add one MasterData band and several DetailData bands on your report's page
  • edited April 2011
    gpi wrote: »
    Yes, it's possible. Add one MasterData band and several DetailData bands on your report's page
    Yes, but that would first print entire masterdata for first record and then all three details. What I need is to print some master data, then print first detail, then again some master data (same record), then second detail, then some more masterdata and third detail.
    So, three detail data mixed with masterdata in output.

    Think cardview layout with multiple details inside (for each record).
  • gpigpi
    edited 1:24PM
    Use DetailData band with RowCount=1 for MasterData data
  • edited 1:24PM
    gpi wrote: »
    Use DetailData band with RowCount=1 for MasterData data

    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.
  • gpigpi
    edited 1:24PM
    Use

    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
  • edited 1:24PM
    Thanks for reply, btw.

    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.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.