Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Subreport detail (on next page)

edited August 2008 in Subreports
Hi everybody!

I work with Delphi 2007 and RB 10.06.

I have a subreport in the detail band and when the subreport detail reach 19
records i need to repaint the main (parent) report to another page, and from
the next page, the subreport detail needs to start printing from the 20th
record, and so on.

How do I do it ?

Ricardo Tavares
tavares@sequence.com.br

Comments

  • edited August 2008
    Hi Ricardo,

    Try using the DetailBand.PrintCount property to limit the number of details
    printed on each page. You can also set the subreport to KeepTogether so
    that a new page will start or perhaps place it into a NewPage group.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2008
    Hi Nico,

    I'm using the DetailBand.PrintCount property = 19 and I set the subreport to
    KeepTogether also, but it don?t work.

    Also, I haven?t found the NewPage group property you mentioned .


    Any Ideas ?



  • edited August 2008
    Hi Ricardo,

    In my testing placing a group around each subreport did the trick. Simply
    create a group based on the master field in the main report and in the group
    dialog, set the Create New Page option to true.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2008
    Hi Nico!

    Thanks for your tips! but to my case don't work.
    I go explain everything that's happening.
    I have two datasets, one in the report main and other in the subreport.
    One record of the dataset main Report will can to have many records in the
    dataset Subreport.
    One page contained two record of the main report when subReport has 18
    record or less, when the subreport has 19 record or more one page will have
    just one record, but when the subReport printCount property = 19 will need
    reprint all report, main and detail, and restart the subreport from the
    20th record.

    How do I do it?


  • edited August 2008
    Hi Ricardo,

    I created the following example to show what I meant. This report does
    exactly what you describe below only I limited the number of details in the
    subreport to 3. The rest of the entire report is printed on each page after
    three details are generated.

    http://www.digital-metaphors.com/tips/LimitSubreportDetails.zip

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2008
    Hi Nico !

    Thanks you very much for your example, it was really helpful.
    But, I like to print the same person in the same page? and not in the next
    page.
    Following exemple file.




  • edited September 2008
    Hi Ricardo,

    For future reference, please send all examples and attachments to
    support@digital-metaphors.com.

    I'm not sure I understand what you mean by printing the same person in the
    same page. In the example I sent, the company was re-printed on each page
    after the limit on details was met, similar to your example.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2008
    Hi Nico,

    Sorry, because I sent the picture for wrong place.
    I understand your exemple, but I would like to print the same person in the
    same page.
    Is this a possible ?
    How I do It ?

    Thanks!



  • edited September 2008
    Hi Ricardo,

    I'm sorry but I still do not understand what you are trying to accomplish.
    Perhaps if you send me an example of what you would like your report to look
    like to support@digital-metaphors.com I will be able to better understand
    what you need and better help you find a solution.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2008
    Hi Nico!

    Do you have any notice from my example?


  • edited September 2008
    Hi Ricardo,

    Yes I received your email and sent a reply. I am not able to extract .rar
    archives. Please resend the example in .zip format and I'll take a look at
    it for you.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.