"hidden" detail?
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.
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.
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com