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

Subreport Issue

edited July 2003 in Subreports
Hi, all.

I'm using RB 6.01, Delphi 6. I have a three-tier report application: a
front-end that runs a report which draws data from a DataSnap (Midas)
middle-tier which in turn draws data from an Oracle 9i database.

The report in question has a detail band with several fields drawing from
the master dataset. In the same detail band there are 3 subreports which
provide detail records. The first two subreports draw data from views in the
backend; the last one from a stored procedure. While these three subreports
provide detail, there are no [master-detail] relationships defined (the data
from these three subreports gets properly filtered in the middle-tier).

The issue I am having is that when I run the report, the first two
subreports (the ones that draw data from views in the backend) print
correctly, but the last one (the one with the stored procedure) does not
print. I have tested the data coming from the client datasets and placed
database grids connected to the subreport data sources and the correct
detail data is displayed (i.e., the subreport pipelines are being provided
with the correct detail records). Is there any issue with pipelines and
client datasets that draw data from Oracle stored procedures? Can you shed
some light on this weird issue?

Thanks in advance!

Rudy

Comments

  • edited July 2003
    No there ins't an issue. It should print because RB relies on the TDataset
    interface to get the data from the client dataset.

    1. Make sure that you are not setting that detail datapipeline's
    MasterFieldLinks and MasterDatapipeline properties as this would break the
    linking you have setup on the dataset components.

    2. Then make sure that the subreport has its DataPipeline property set.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.