Reporting behaviour

rbuser

Greetings,

I have a report that is behaving in a strange way.

The report has a main page with headers etc and a subreport
that sub report then has three other sub reports,

The report lists "file notes" (text records) each of which may have...
zero to many "amendments", "attachments", or "action requests".
when the count is zero, nothing of the sub item prints not even headers.

The problem is that this all works perfectly in the report designer
preview, but when a user runs the report; the first attachment prints on
every file note.


Any help will be greatly appreciated.

Cheers
David.


Report Builder V12.03
all Sub reports are selected as "Child"
Delphi XE

nicocizik

Hi David,

This is not a known issue with RB 12.03 however I am going to need more
information about your report to understand exactly what might be happening.

How many separate datasets is the report using? Which datasets are
connected to which subreports/report? Is this a Master-Detail report?

Which event(s) are you toggling the visibility of the subreports or the
components inside the subreports? Are you certain this code is being fired
correctly for the given circumstances?

You mention that when a user runs the report the issue occurs. Are you able
to recreate the same behavior when you run the report?


Regards,

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

rbuser

"Nico Cizik \(Digital Metaphors\)" wrote

nicocizik

Hi David,

Thanks for the additional information. I'm still stumped on how this is
working correctly at design-time but not at runtime.

ReportBuilder will simply retrieve the data that is present from a connected
dataset. As a test, you might try adding a few DBGrids to your app form
(connected to each dataset) so you can view live the data being accessed
while the report is generated. My guess is that for a given master, the
data for the subreport(s) is incorrect.

Also, be sure the Pipeline.SkipWhenNoRecords property of the detail
pipelines is set to True. This will ensure that the master record for an
empty detail is skipped rather than given to the report.


Regards,

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

rbuser

"Nico Cizik \(Digital Metaphors\)" wrote

nicocizik

Hi David,

Thanks for the information. We will look into this further however what we
really need is a simple example that demonstrates the issue that we can run
on our machines. If you would like to pursue this issue further, please
send an example to support@digital-metaphors.com in .zip format and we'll
take a look at it for you.



Regards,

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