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

"hidden" detail?

edited July 2006 in Subreports
Hi,

I have a subreport and at one point it skips 9 detail bands when going to a
new page.
It looks like this:

[Page1]
...
no. name amount
6 Willenswaard van - Broeke van 187,95

7 Wit de - Griek van de, MH 154,28

8 Aarnoutse, JSM 51,31

Datum: 13-7-2006 9:07:18 Page 3 of 10 <=- page footer

[Page 2]

17 Hout, JC 21815 147,07
18 Winter de - Pundert de, CE 187,95

19 Bliek - Feijter de, JP 140,07

....


It only does this once, going from page 3 to 4, on other times when the
detail of the same subreport is displayed on multiple pages it does not
behave like that.
The strange thing is that the DBCalc Count component, under the no. label,
goes from 8 to 17 and the DBCalc Sum component, that's in the summary of the
of the subreport sums up to the right amount. So the data is probably there
it just does not show it.
Any idea how to solve this problem?

I'm using RB 7.04 with Delphi 6.

Greetings,
Ranjii.

Comments

  • edited July 2006
    Hi Ranjii,

    I have not seen this behavior before. ReportBuilder simply retrieves data
    directly from the dataset it is given. What type of subreport are you
    using? If it is a fixed subreport, there may be a patch available that
    could fix your problem.

    --
    Regards,

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

    Best Regards,

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

    It is a child subreport (actually a child subreport of a child subreport).
    I am sure the data is there, because if I move some stuff around so all the
    records are on the same page all the records are showing.

    Greetings,
    Ranjii

  • edited July 2006
    Hi Ranjii,

    Are you able to recreate this behavior in a simple minimal example? As a
    test try simplifying your report as much as possible (comment out all event
    code) and see if you can find the issue. If the issue no longer occurs when
    you remove all event code, periodically begin adding the code back to try to
    isolate the issue.

    --
    Regards,

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

    Best Regards,

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

    No luck. I removed all the event code and cut down the subreports from 30 or
    so to 9 and the pipelines from 15 or so to 6, but it still does the same
    thing. It's really odd because the report is 9 pages now and the detail
    bands of the subreport is printed across 2 pages 4 times and "skips" detail
    bands only that one time, the other 3 times it's doing fine.

    Grettings,
    Ranjii

  • edited July 2006
    Hi Ranjii,

    9 subreports and 6 pipelines is still not a very simple report :). I would
    suggest simplifying it even more, even perhaps starting from a new report
    and trying to recreate the issue with as few subreports and pipelines as
    possible. My guess is that some records are being overlapped by another
    subreport in the report. Perhaps there is a subreport that does not have
    its ShiftRelativeTo property properly set.

    --
    Regards,

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

    Best Regards,

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

    I needed all that data to reproduce the behaviour. I ran the report on
    Report Builder 10.03 trial and it seems to do fine.
    I was thinking if I could try that patch you were talking about earlier,
    maybe it will fix my problem? Because migrating to 10.03 is a lot of work.

    Greetings,
    Ranjii

  • edited July 2006
    Hi Ranjii,

    If you would like to try the patch, please send an email to
    support@digital-metaphors.com requesting it and we'll get it to you asap.
    I'm unsure this will make a difference but it is worth a try.

    --
    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.