Report with recursive data

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

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 11:15PM
    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.
    ;)
  • edited 11:15PM
    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
  • gordkgordk St.Catherines On. Canada.
    edited 11:15PM
    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.
    ;)
  • edited 11:15PM
    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

Leave a Comment