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

Detail pipelines problem

edited March 2004 in Subreports
I have a problem using pipelines on 3rd level. For example I have 3
pipelines:

Table : SOME_TABLE (ID , FIELD1, FIELD2, FIELD3)

first pipeline -> 'select field1 from some_table group by field1'
second pipeline -> 'select id, field1, field2 ,field3 from some_table'
third pipeline -> 'select field1, field2 from some table group by field1,
field2'

second is joined to first (master - detail) by field1
third is joined to second (master - detail) by field1 and field2

I what to have one report that show data grouped by field1, then subgroup by
field2.
I have a problem with 3rd pipeleine - no data in this pipeline. How to solve
this problem?

Comments

  • edited March 2004
    Hello,

    I'm unclear what the issue is. If there is no data in your dataset, you can
    use the NoDataBehaviors property of the report to instruct it what to do
    under this circumstance. Also there is a SkipWhenNoRecords property
    available on the TppDBPipelines that may be useful for your needs. Perhaps
    a little more information about what you are trying to accomplish would help
    me find a quicker solution for you.

    --
    Best Regards,

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