Report with recursive data

wkuehnis

Hi,
a have a database with a very simple structure, which builds tree-like structures.

I have the following data (of course some more fields)
ID
ParentID

When the parentID is NULL, then it's a top-Level

Now in fastreport, I want to show this data of all this levels.

Any ideas?

Thanks
Willi

gordk

Willi if you can get the data into a treelist fr can print the list
goto the public binaries news group there is a demo posted there.

wkuehnis

Thanks for this tip,

I also can use this.
but I couldn't find this "public binaries"

But:
I think, I wrote it not very clearly: I don't want to show only this tree, for each "node" of this tree I want to show more data (address, Memos...).
So maybe I can create databands in a recursive way. But I don't know how to do it in a report

gordk

willi
newsgroups are at
nntp://198.63.208.239
fastreports.public.binaries.
remember a data band is just a place holder on a design page, which controls the formatting of the produced page. it can be connected to virtual n records, frdbdatset, or fruserdataset where you control record positioning.

wkuehnis

Hi
I think, I still could explain, what I want. I think, it would not be a problem to generate the report over the tree-like database-structure in Delphi.

But I have a system, where the customer can make all his reports.
I have to do it in fastreport - that's my problem.

Thanks
Willi