Hello!!

I have question about reports. I want to do report with some result like this:

All Project                      Varible for each of this project

Information about "all project" I can have with help of this reports

Select P.Name

From Projects P, ProjectTree Pt, Projects P2

where P.ProjectID > 1 And

  P2.Path Like '\Projects\' And

  P2.ProjectID = Pt.ProjectID And

  P.ProjectID = Pt.ChildProject

Order By P.Name ASC

But I want have one column with one of varible of each of folder.

Can Yot help me??

Thanks!!!