RE: Detail pipelines

rbuser

I'm using the report designer to create custom reports.

The three pipelines get data from one and the same table in the data base.
The difference is that the first and the third pipelines group the data on
certain criterias.
For example:

SOME_TABLE
ID Field1 Field2 Field3
1 1 1 1
2 1 2 2
3 1 2 3
4 2 1 4

The first pipeline must have as a result (group by field1) and this is
exactly what I get:
Field1
1
2

The second pipeline must have as result and this is so, no problems so far:
ID Field1 Field2 Field3
1 1 1 1
2 1 2 2
3 1 2 3
4 2 1 4

However, the third pipeline must have as result (group by field1,field2) the
following:
Field1 Field2
1 1
1 2
2 1

If I preview the result of the pipelines in the Report Designer, the data
above is exactly what I get, in other words, the data is extracted properly
from the database, just like I want it to be.

I connect the third to the second by :
second.field1 = third.field1
second.field2 = third.field2

and I expect that I will have data in the third (when the second change its
position), but I get no data in the third pipeline when I do Print the
report..

I created some calculated fields in third pipeline and show thats in Group
Footer.

The Report must look like that (data pipeline is set to the first pipeline):

TITLE

--Group header : field1

--sub report
--sub report group header : field2
--sub report details (contains boot data from pipeline 1 and 3) - there i
expected data from 3rd pipeline
--sub report group footer : field2
--end sub report

--Group footer : field1

nicocizik

Hi Daniel,

Be sure you are not linking your datasets as well as linking the pipelines.
In my testing with the exact table below and your exact queries, the third
pipeline showed its data perfectly. If possible, please send a small
example demonstrating this behavior in .zip format to
support@digital-metaphors.com.

--