Using data from one pipeline as input for a dataview
Hi all,
I've created my own pipeline TSNGGroupedPipeline, which uses three tables
in a NexusDatabase. The pipeline adds functionality making it possible to
print a tree-like structure of dynamic groupheaders and -footers. The report-template
is changed at runtime, adding groups, and creating DBText-components based
on the visible fields of the tables in the NexusDatabase. It also sets the
BeforeGroupHeaderPrint event to call a method from the TSNGGroupedPipeline.
I also add a dataview to the report (at runtime), consisting of a simple
SQL-statement like "select * from tbDetails"
This is done to give the enduser the possibility to modify this SQL-statement,
adding filter expresions, or calculated aggregates.
When i create the dataview, it creates its own pipeline, and that pipeline
is set as the datapipeline of the report.
What i would like to have is a situation where my own TSNGGroupedpipeline
is the main pipeline of the report, serving data to the dataview. You could
say i would like to use the pipeline like a Linux-style commandprompt pipeline.
Can anybody help me in setting this up?
On a higher level, the purpose of this whole exercise is to create multi-purpose
reports capable of visualizing a tree-structure stored in a GroupTable -
(detailslines for each group stored in a Detailstable), with the added ability
to have the user add his own aggregates or calculations.
The grouptable consists of a GroupID, ParentID an some group data
The detailtable consists of an OrderiD, DeepestgroupID and other detail data
Maybe anybody has a brilliant idea on this too...
thanks in advance
Bas Schouten
S&G and Partners
I've created my own pipeline TSNGGroupedPipeline, which uses three tables
in a NexusDatabase. The pipeline adds functionality making it possible to
print a tree-like structure of dynamic groupheaders and -footers. The report-template
is changed at runtime, adding groups, and creating DBText-components based
on the visible fields of the tables in the NexusDatabase. It also sets the
BeforeGroupHeaderPrint event to call a method from the TSNGGroupedPipeline.
I also add a dataview to the report (at runtime), consisting of a simple
SQL-statement like "select * from tbDetails"
This is done to give the enduser the possibility to modify this SQL-statement,
adding filter expresions, or calculated aggregates.
When i create the dataview, it creates its own pipeline, and that pipeline
is set as the datapipeline of the report.
What i would like to have is a situation where my own TSNGGroupedpipeline
is the main pipeline of the report, serving data to the dataview. You could
say i would like to use the pipeline like a Linux-style commandprompt pipeline.
Can anybody help me in setting this up?
On a higher level, the purpose of this whole exercise is to create multi-purpose
reports capable of visualizing a tree-structure stored in a GroupTable -
(detailslines for each group stored in a Detailstable), with the added ability
to have the user add his own aggregates or calculations.
The grouptable consists of a GroupID, ParentID an some group data
The detailtable consists of an OrderiD, DeepestgroupID and other detail data
Maybe anybody has a brilliant idea on this too...
thanks in advance
Bas Schouten
S&G and Partners
This discussion has been closed.
Comments
You might consider creating your own custom dataview. For examples see
Demos\EndUser\Custom DataViews.
I do not have a clear understanding of what you trying to do, but another
way to approach would be to pre-process your data and build the tree
structure in memory or populate a TTreeView. Then write a DataPipeline that
can traverse the tree. There was a customer who created treeview and
listview datapipelines and we have a download link on our web site. However
I just tried the link and it no longer works. I just emailed the author to
inquire, but I don't know whether the email address is still valid
either.You could try emailing him also. See this page.
http://www.digital-metaphors.com/download/data_pipelines.html
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com