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